Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

techvarun
Valued Contributor 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
MVP
MVP

Re: Some numbers formatted as string

Try

LOAD

     Evaluate(FIELD) as FIELD,

     ...

FROM ....;

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

5 Replies
MVP
MVP

Re: Some numbers formatted as string

Try

LOAD

     Evaluate(FIELD) as FIELD,

     ...

FROM ....;

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

techvarun
Valued Contributor II

Re: Some numbers formatted as string

Thanks a lot Stefan

Much appreciated

techvarun
Valued Contributor II

Re: Some numbers formatted as string

Hi Stefan,

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

Thanks in advance

MVP
MVP

Re: Some numbers formatted as string

If you accept HIC as a reference:

limited rounding | Qlik Community

techvarun
Valued Contributor II

Re: Some numbers formatted as string

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

Thanks

Varun

Community Browser