Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
hic
Former Employee
Former Employee

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

View solution in original post

4 Replies
sushil353
Master II
Master II

can u upload the sample app or data?

Not applicable
Author

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

hic
Former Employee
Former Employee

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
Author

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