How to load BIG NUMBERS in Qlik?

How to load BIG NUMBERS like more than 14,15 and even 17 digits?

How to load BIG NUMBERS like more than 14,15 and even 17 digits?

If you want all 16 digits, and treat it like text, you can load it as

Text(Field)

but then you cannot use it as a number.

You can also load it using

Dual(Field, Evaluate(Field))

Then you will get the original string (all 16 digits) as the textual value, and the evaluated string as numeric value. This works fine as long as you don’t have two field values with identical 15 digits, but different 16th digit.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.