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?
in the script, try to change it as follow:
num(YourNumber,'(dec)') as YourNumber
but the actual number is 20140403500119
have u tried this in ur script? ...
num(YourField,'(dec)') as YourField
Thank You Sir, Can you explain me how '(dec)' works?
Retrieving data ...