Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?