Some numbers formatted as string

[techvarun]

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.

[swuehl · Accepted solution]

Try

LOAD

     Evaluate(FIELD) as FIELD,

     ...

FROM ....;

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

[techvarun]

Thanks a lot Stefan

Much appreciated

[techvarun]

Hi Stefan,

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

Thanks in advance

[swuehl]

If you accept HIC as a reference:

limited rounding | Qlik Community

[techvarun]

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

Thanks

Varun