Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think that are too many significant digits you are trying to display, but in general, try something like
=num(-7.4050016e-005,'#.00000000000000','.',',')
Hi,
Thanks for ur response.
Can we get exact value using exponential function in qlikview ?
Thanks in advance.
Regards,
Venkat