Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert Exponential value to decimal

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

2 Replies
swuehl
MVP
MVP

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

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

Not applicable
Author

Hi,

Thanks for ur response.

Can we get exact value using exponential function in qlikview ?

Thanks in advance.

Regards,

Venkat