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.
Evaluate(FIELD) as FIELD,
Note that Qlik won't be able to actually store more than 14 significant digits, AFAIR.
Thanks a lot Stefan
One more query. is the 14 digit restriction documented anywhere? I searched in the community unable to find.
Thanks in advance
If you accept HIC as a reference:
limited rounding | Qlik Community
Yes of-course I accept HIC and you as a reference.
Retrieving data ...