Discussion board where members can get started with Qlik Sense.
I need to export the data to CSV, but I need to make the decimal separator a dot, not a comma. Changing the "DecimalSep" in global variables does not change this.
I also have a lot of fields in the data and I'm not smiling using "replace" or something like that.
This should work
STORE Test INTO [test.csv](txt, delimiter is '.');
Does changing the seperators from the data load editor solve your problem?
No, I don't think so. Delimiter is used for something else - separates the fields from each other.
I need the simple dot format to be in the fields where I have numbers.
Sample field - "sales".
Now I have format: 3 001,54
After export to CSV have to be: 3001.54
SET ThousandSep='';SET DecimalSep='.';SET MoneyThousandSep='';SET MoneyDecimalSep='.';SET MoneyFormat='$# ##0.00;($# ##0.00)';
It doesn't work 😞