topic Numbers Formatting in QlikView

Numbers Formatting

Wed, 03 Nov 2010 01:38:41 GMT

Does click view support Scientic Formating? I want to display very small number as 2.25E-02.

0.0225 = 2.25E-02

Numbers Formatting

pover — Wed, 03 Nov 2010 04:18:57 GMT

In the number tab if you set the expression to type number and give it a low precision scientific notation will be used.

Numbers Formatting

Wed, 03 Nov 2010 06:19:24 GMT

Hi,

You can try by using 'num' function

Ex:

num(2.25E-02) It will give you the result you expceting.Try and let me know

Thanks & Regards

Jai

Numbers Formatting

Fri, 05 Nov 2010 21:05:23 GMT

In the image I want the display to look like the Format display, I can't seem to do that?

Numbers Formatting

pover — Sat, 06 Nov 2010 22:32:22 GMT

There should be a way to do this in the number format, but using 'e' doesn't seem to work. You can try this workaround that works when the number is less than 1 and greater than 0. The result it returns is a string.

=num(PurgeChar(num(0.00584),'.'))/pow(10,len(num(PurgeChar(num(0.00584),'.')))-1)
&'e'&(-(len(num(0.00584))-len(num(PurgeChar(num(0.00584),'.')))-1))

Just replace num(0.00584) with the field that you want to convert and you might need an if to evaluate if it is less than 1. Playing with this same type of formula, you should be able to format other numbers less than 0 or greater than 1.

Regards.