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

Qlikview does not recognize numbers in the list box

Hi guys, I'm really new to the Qlikview program so please understand even though question is stupid

I just reload all data from csv files and tried to make some chart and statistical box.

However, the numbers for some list box(Price and Total) has separator setting that is different to my computer has

It has "," for decimal and "." for the thousand and it's opposite for my region setting.

I also have tried to change region setting, but unfortunately it is not working.

So right now, I can not use any function like Sum or Average when I make chart with those list boxes.

Is there any way that I can make my computer recognize numbers??

6 Replies
Not applicable
Author

That's not a stupid question at all.  Use SET ThousandSep=','; and SET DecimalSep='.'; in the script.

Not applicable
Author

Hmm.. adjusting script doesn't work for some reason

Where can I put Num(Sum(YourField),'###,###.##') in the list box? Property maybe?

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

you can change these settings in the system variables, located in the main tab in script. This way you can change format settings like decimal and thousand separators, as well as other things like date/time format and names for months and days of the week.

regards

script.PNG.png

tresesco
MVP
MVP

May be it is getting loaded into qv so. If so, try something like this in the script:

Load

          Num(PurgeChar(YourField, ',.')) as YourField

From <CSV file>;

Not applicable
Author

I tried that, I mean I do have access to the script and I also changed it

however, when I tried to make a chart and using Sum or Average function Qlikview doesn't allow to use

certain list box at all. Also When I tried to make statistical box, most of values showed n/a.....

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

You can try with Num#()

Assuming you have format has '###,###.##'

Then you could use Num(Num#(FieldName, '###,###.##'))