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: 
qlikeers
Creator II
Creator II

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
Creator III
Creator III

This should work

 

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

emrekaya
Contributor III
Contributor III

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

qlikeers
Creator II
Creator II
Author

@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 😞