Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nicolas_martin
Contributor 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
Honored Contributor II

Re: Change decimal separator for the whole application

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

2 Replies
prieper
Honored Contributor II

Re: Change decimal separator for the whole application

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
Contributor II

Re: Change decimal separator for the whole application

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

Community Browser