topic Re: Script load numeric values from excel are diverging in QlikView

Script load numeric values from excel are diverging

Anonymous — Wed, 07 Feb 2018 13:25:57 GMT

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 — Wed, 07 Feb 2018 13:36:00 GMT

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

SET ThousandSep=',';

SET DecimalSep='.';

Anonymous — Wed, 07 Feb 2018 15:26:17 GMT

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.