Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Number Format Error - Decimal / Thousand Separator problem?

Hi there,

I found number format error in my file.

Data in database (format numeric) : 10000.00000, 150.00000, 70.00000  <-- '." is decimal format

I'd set thousand and decimal separator format on edit script.

SET ThousandSep=',';

SET DecimalSep='.';

After reload I get wrong number.

10000.00000 should be 10.000, but the number become 1.000.000.000

150.00000 should be 105, but the number become 15.000.000

70.00000 should be 70, but the number become 7.000.000

how to solve this error? This is because the separator problem?

Thanks before.

Regards,

Heri

1 Solution

Accepted Solutions

Re: Number Format Error - Decimal / Thousand Separator problem?

Could very well be a separator problem.

Itsangad's suggestion is a good way to check what you really have loaded, but it will not solve you problem if there is a problem. To solve it you may need to use the Num#() function to interpret it correctly, e.g.

Num#( Field, '#', '.', ',') as InterpretedField

HIC

4 Replies
sushil353
Honored Contributor II

Re: Number Format Error - Decimal / Thousand Separator problem?

can u upload the sample app or data?

Not applicable

Re: Number Format Error - Decimal / Thousand Separator problem?

Hello Heri,

After you reload, you go to Number Tab of your Listbox or chart to change its format.(Use Interger format)

Or to check the default format, you can check on Document Properties->Number tab.

Please let me know if this was helpful, or anything else is required.

thanks,

itangad

Re: Number Format Error - Decimal / Thousand Separator problem?

Could very well be a separator problem.

Itsangad's suggestion is a good way to check what you really have loaded, but it will not solve you problem if there is a problem. To solve it you may need to use the Num#() function to interpret it correctly, e.g.

Num#( Field, '#', '.', ',') as InterpretedField

HIC

Not applicable

Re: Number Format Error - Decimal / Thousand Separator problem?

Thanks Henric and Itangad for your solution

I think its because of the Regional location setting on computer. After I change to my region (Indonesia) and try to reload again, the problem is solve.

Thanks.

Regards,

Heri