Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
techvarun
Specialist II
Specialist II

Some numbers formatted as string

Hi Experts,

I have an amount column in the database inthis i have some of the amounts formatted as string and i am getting a huge mismatch

I have tried Num#() and *1 but nothing worked.

Please suggest a workaround to fix this permanently in the load script.

Capture.PNG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

LOAD

     Evaluate(FIELD) as FIELD,

     ...

FROM ....;

Note that Qlik won't be able to actually store more than 14 significant digits, AFAIR.

View solution in original post

5 Replies
swuehl
MVP
MVP

Try

LOAD

     Evaluate(FIELD) as FIELD,

     ...

FROM ....;

Note that Qlik won't be able to actually store more than 14 significant digits, AFAIR.

techvarun
Specialist II
Specialist II
Author

Thanks a lot Stefan

Much appreciated

techvarun
Specialist II
Specialist II
Author

Hi Stefan,

One more query. is the 14 digit restriction documented anywhere? I searched in the community unable to find.

Thanks in advance

swuehl
MVP
MVP

If you accept HIC as a reference:

limited rounding | Qlik Community

techvarun
Specialist II
Specialist II
Author

Yes of-course I accept HIC and you as a reference.

Thanks

Varun