topic Number Format Error - Decimal / Thousand Separator problem? in QlikView

Number Format Error - Decimal / Thousand Separator problem?

Mon, 18 Mar 2013 09:23:56 GMT

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

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

sushil353 — Mon, 18 Mar 2013 09:37:48 GMT

can u upload the sample app or data?

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

Mon, 18 Mar 2013 10:13:56 GMT

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?

hic — Mon, 18 Mar 2013 14:18:55 GMT

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

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

Wed, 20 Mar 2013 11:25:54 GMT

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