Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How QV reads Exponential values?

Hi all,

I am creating QVD files but their is an issue, Whereever I have Exponential values in my CSV files QVD read it as zero(0).

Please help me out.

Regards

Sagar Gupta

1 Reply
Miguel_Angel_Baeyens

Hello Sagar Gupta,

Which format do your values have?

If you use the Num() or Num#() function on the following values, they will be correctly read:

Num(25e3) // 25000

Num(25e-3) // 0.025

Num(25e+3) // 25000

Hope that helps.

Miguel