topic Re: Not able to get Percentage format for a Large Number in QlikView

Not able to get Percentage format for a Large Number

anshulsri — Tue, 27 Mar 2018 10:40:21 GMT

Hi All,

We have some calculation in our dashboard , because of that we are getting number like -4.46428976454634e+014. If we convert it in decimal it comes in 16 digits. We have to get this number in % format and for that I am using '##.#%;(##.#)%' with NUM function. But eventually, for this number I am getting ()% since it is a negative number and not the full number.

Please let me know if anybody could help me on it.

Re: Not able to get Percentage format for a Large Number

marcus_sommer — Tue, 27 Mar 2018 12:14:11 GMT

Your number is just too big (in relations to the number of digits) to be treated as a number in Qlik. If you don't mandatory need these exactness than you should reduce the number of digits maybe by dividing your results with 1 k/m/g and/or with a rounding-functions and/or with string-functions like left() or similar.

This is caused by the used number-system which is IEEE 754. Here some background to this topic: Rounding Errors.

- Marcus