Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

Exponential Number To Real Number Without Rounding off

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?

1 Solution

Accepted Solutions
OmarBenSalem

have u tried this in ur script? ...

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

View solution in original post

4 Replies
OmarBenSalem

in the script, try to change it as follow:

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

result:

Capture.PNG

=>

Capture.PNG

baarathi
Creator III
Creator III
Author

but the actual number is 20140403500119

OmarBenSalem

have u tried this in ur script? ...

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

baarathi
Creator III
Creator III
Author

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