Script load numeric values from excel are diverging

[Anonymous]

Someone face this anytime?

I have a spreadsheet with some values, and when i load into qlikview, the values shows wrong.

Follow the screenshots, and the files if someone wants test the behavior.

Ex. of value: COD_REP = 1067 and FA03 = 6688,13

How appears on xlsx import.

And how is loaded.

[sunny_talwar · Accepted solution]

Not sure what your environmental variables are, but changing to this helps

SET ThousandSep=',';

SET DecimalSep='.';

[Anonymous]

Hi Sunny.

Tks for your reply. For test environments i don't set any variable.

So, when I put only the DecimalSep='.' worked fine.

Another solution i realize, was changed the columns with values in excel file.

from: Number

to: General

Works fine too.