topic Re: Convert Exponential value to decimal in QlikView

Convert Exponential value to decimal

Wed, 08 Jan 2014 15:59:29 GMT

Hi all,

Can anyone let me know how to change the exponential value to decimal value using qlikview expression. Below is the example value

-7.4050016e-005 should change to the -0.0000740500162390435

Please suggest your ideas on this.

Thanks in advance.

Regards,

Venkat

swuehl — Wed, 08 Jan 2014 16:03:14 GMT

I think that are too many significant digits you are trying to display, but in general, try something like

=num(-7.4050016e-005,'#.00000000000000','.',',')

Wed, 08 Jan 2014 16:43:17 GMT

Hi,

Thanks for ur response.

Can we get exact value using exponential function in qlikview ?

Thanks in advance.

Regards,

Venkat