Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
leandro_job
New Contributor III

Script load numeric values from excel are diverging

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.

excel.png

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

import.PNG

How appears on xlsx import.

qlik.png

And how is loaded.

1 Solution

Accepted Solutions

Re: Script load numeric values from excel are diverging

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

SET ThousandSep=',';

SET DecimalSep='.';

2 Replies

Re: Script load numeric values from excel are diverging

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

SET ThousandSep=',';

SET DecimalSep='.';

leandro_job
New Contributor III

Re: Script load numeric values from excel are diverging

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.

Community Browser