Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
That's not a stupid question at all. Use SET ThousandSep=','; and SET DecimalSep='.'; in the script.
Hmm.. adjusting script doesn't work for some reason
Where can I put Num(Sum(YourField),'###,###.##') in the list box? Property maybe?
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
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>;
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.....
Hi,
You can try with Num#()
Assuming you have format has '###,###.##'
Then you could use Num(Num#(FieldName, '###,###.##'))