Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Re: number of 17 digits

I have this number:98765432198765432 composed of 17 digits when read by qlikView I read the following:9.87654E+16  how can I display the above number as is?

I can walk on water when it freezes
5 Replies
Not applicable

If I want to display a number (used as an expression).

Setting the number format settings to fixed to 0 will be enough.

Otherwise Num(YourNumber, '#.##0') can be used

Not applicable

Number format '00000000000000000'

can also be used.

That way you'll get exactly 17 numbers without interpunction.

nizamsha
Specialist II
Specialist II

in the number format tab  check that fixed to '2' so u can display all the number like u want

ThornOfCrowns
Specialist II
Specialist II

Try the answer you accepted in this thread a few days ago: http://community.qlik.com/thread/91778

ali_hijazi
Partner - Master II
Partner - Master II
Author

the number should end with 01 not 00

I can walk on water when it freezes