Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
qlikeers
New Contributor III

Store function - dots instead of commas

Hi!

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.

 

Any ideas?

Labels (5)
3 Replies
asinha1991
Contributor

Re: Store function - dots instead of commas

This should work

 

STORE Test INTO [test.csv](txt, delimiter is '.');

emrekaya
New Contributor III

Re: Store function - dots instead of commas

Does changing the seperators from the data load editor solve your problem?Capture.PNG

qlikeers
New Contributor III

Re: Store function - dots instead of commas

@asinha1991 

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

 

@emrekaya 

I have:

SET ThousandSep='';
SET DecimalSep='.';
SET MoneyThousandSep='';
SET MoneyDecimalSep='.';
SET MoneyFormat='$# ##0.00;($# ##0.00)';

It doesn't work 😞