Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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!
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
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!
Hi,
Try like this
=Num(Num, '###0.##')
This will round off to 2 decimal points and show you as a normal number.
Regards,
Jagan.
it's working thank you very much
it's working thank you very much