baarathi
Creator III
2018-01-08
07:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- qliksensedevelopers
1,614 Views
1 Solution
Accepted Solutions
OmarBenSalem
MVP
2018-01-08
07:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
have u tried this in ur script? ...
num(YourField,'(dec)') as YourField
1,522 Views
4 Replies
OmarBenSalem
MVP
2018-01-08
07:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
in the script, try to change it as follow:
num(YourNumber,'(dec)') as YourNumber
result:
=>
baarathi
Creator III
2018-01-08
07:30 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
but the actual number is 20140403500119
1,522 Views
OmarBenSalem
MVP
2018-01-08
07:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
have u tried this in ur script? ...
num(YourField,'(dec)') as YourField
1,523 Views
baarathi
Creator III
2018-01-08
08:33 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank You Sir, Can you explain me how '(dec)' works?
1,522 Views