topic Some numbers formatted as string in QlikView

Some numbers formatted as string

techvarun — Wed, 14 Mar 2018 09:11:29 GMT

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 — Wed, 14 Mar 2018 09:26:20 GMT

Try

LOAD

Evaluate(FIELD) as FIELD,

...

FROM ....;

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

techvarun — Wed, 14 Mar 2018 09:31:13 GMT

Thanks a lot Stefan

Much appreciated

techvarun — Wed, 14 Mar 2018 12:38:17 GMT

Hi Stefan,

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

Thanks in advance

swuehl — Wed, 14 Mar 2018 12:50:15 GMT

If you accept HIC as a reference:

techvarun — Thu, 15 Mar 2018 11:42:08 GMT

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

Thanks

Varun