Exponential Number To Real Number Without Rounding off

[baarathi]

I have got a value 20140403500119, this value when I load it in qliksense it displays as 2.0140403505012e+14. But i want to display it as 20140403500119 in qliksense, any idea?

[OmarBenSalem]

in the script, try to change it as follow:

num(YourNumber,'(dec)') as YourNumber

result:

=>

[baarathi]

but the actual number is 20140403500119

[OmarBenSalem · Accepted solution]

have u tried this in ur script? ...

num(YourField,'(dec)') as YourField

[baarathi]

Thank You Sir, Can you explain me how '(dec)' works?