Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolas_martin
Partner - Creator II
Partner - Creator II

Change decimal separator for the whole application

Hello,

I have an application with many metrics.

It was created with a spectific decimal separator and thousand separator.

Now, I'ld like to change these separators.

If I change the variables

SET ThousandSep='';

SET DecimalSep='.';

it'll change only the new expressions I'll create in the future, not the one already created.

Is there a way to simply apply the decimal / thousand separator for the whole application?

As I have a copy of the same application for more than 1 client, the best for me would be to have a parameter I can include in a parameter file. Each client would be able to have the format he wants.

1 Solution

Accepted Solutions
prieper
Master II
Master II

you may set number-properties across the document under Settings -> Document Properties ->Number.

Else you may create a variable toggling between e.g.

#.##0,00 and #,##0.00 etc

Your expression then will need to include NUM-command, the expression and your format, e.g.

NUM(SUM(Sales, '$(vMyFormat)')

Peter

View solution in original post

2 Replies
prieper
Master II
Master II

you may set number-properties across the document under Settings -> Document Properties ->Number.

Else you may create a variable toggling between e.g.

#.##0,00 and #,##0.00 etc

Your expression then will need to include NUM-command, the expression and your format, e.g.

NUM(SUM(Sales, '$(vMyFormat)')

Peter

nicolas_martin
Partner - Creator II
Partner - Creator II
Author

I think I'll use the "num()" workaround.