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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

change the format of a number

hello i am trying to change the format of column which contains numbers

as shown in the box

2.35E+20

can anyone tell how to change the format to normal format ?

1 Solution

Accepted Solutions
manas_bn
Creator
Creator

I think this should work:

Num(Num#(YOUR_FIELD_NAME))

For your example, Qlikview will still show 2.35+e020, but it will be stored as a number.


Cheers!

View solution in original post

5 Replies
Not applicable
Author

Hi Tamer,

In chart/table 'Properties' go to 'Number' tab.

Choose your expression on the left and apply the number format settings you wish.

Hope this helps.

Kind regards,

Nuno

manas_bn
Creator
Creator

I think this should work:

Num(Num#(YOUR_FIELD_NAME))

For your example, Qlikview will still show 2.35+e020, but it will be stored as a number.


Cheers!

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

 

=Num(Num, '###0.##')

This will round off to 2 decimal points and show you as a normal number.

Regards,

Jagan.

Anonymous
Not applicable
Author

it's working thank you very much

Anonymous
Not applicable
Author

it's working thank you very much