topic Re: Change decimal separator for the whole application in QlikView

Change decimal separator for the whole application

nicolas_martin — Fri, 05 May 2017 13:36:52 GMT

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.

Re: Change decimal separator for the whole application

prieper — Fri, 05 May 2017 13:42:59 GMT

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

Re: Change decimal separator for the whole application

nicolas_martin — Tue, 09 May 2017 07:55:29 GMT

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