topic Re: Number formatting limit? in QlikView

Number formatting limit?

cesaraccardi — Fri, 30 Aug 2013 10:59:08 GMT

Hi,

I have a field "Value" with numeric values and some of them are huge like 128786317741603 (15 digits). If I create a tablebox or a list in QV to see the value I get this: 1.28786317741603e+14 (no problems here, just scientific notation right?), however if I use this field in a simple expression like sum(Value) the result is displayed as 0! That's wrong!

I have tried to change the format of the expression but without success. Can someone help me, please?

Regards,

Cesar

Re: Number formatting limit?

Fri, 30 Aug 2013 11:03:50 GMT

in expression give the label name is value in lakh

and try expression fieldvalue/100000 then value show in lakh.

Re: Number formatting limit?

cesaraccardi — Fri, 30 Aug 2013 11:12:51 GMT

Hi,

Thanks for your reply and suggestion, I will check with my client the feasibility of doing that. Is this a limitation of QV? The number of digits to be used in calculations? If so, where can I find more information?

Re: Number formatting limit?

Fri, 30 Aug 2013 11:25:01 GMT

see this link, hope this helps you.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/18/number-format-codes

http://community.qlik.com/thread/64618

Re: Number formatting limit?

cesaraccardi — Wed, 04 Sep 2013 14:52:00 GMT

Thanks very much for the usefull links, the solution I have found was to load the fields using the function Evaluate().