Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor

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?

Tags (1)
1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Exponential Number To Real Number Without Rounding off

have u tried this in ur script? ...

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

4 Replies
omarbensalem
Esteemed Contributor

Re: Exponential Number To Real Number Without Rounding off

in the script, try to change it as follow:

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

result:

Capture.PNG

=>

Capture.PNG

baarathi
Contributor

Re: Exponential Number To Real Number Without Rounding off

but the actual number is 20140403500119

omarbensalem
Esteemed Contributor

Re: Exponential Number To Real Number Without Rounding off

have u tried this in ur script? ...

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

baarathi
Contributor

Re: Exponential Number To Real Number Without Rounding off

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