Change Standard NumberFormat

[george55]

Hi all,

I use a Standard load script (see extract below).

SET ThousandSep="'";
SET DecimalSep='.';
SET MoneyThousandSep="'";
SET MoneyDecimalSep='.';

Standard-NumberFormat by Default is "1'000.12" set. Would like to change it to "1000". How can achieve that?

Thanks for any help.

[TimvB]

The following will change the 1'000.12 to 1000.12:

SET ThousandSep='';
SET DecimalSep='.';
SET MoneyThousandSep='';
SET MoneyDecimalSep='.';

In the front end you need to manually set the number format from 1000.12 to 1000. 

Hope it helps!

[george55]

Thanks for your answer. My goal is to avoid in the front end to manually set the number to 1000. Want to avoid because I am doing this so much times. any ideas?

[TimvB]

I do not think you can set a number format by default to use for measures in the front end. You could however create master measures and use the Num() function to set a default number format for that specific measure. Then you can drag and drop these master measures in the visualizations. 

[george55]

Also want to avoid this. Have the opinion a master-item should not be formated. The format should be taken in each object individually. It looks like Qlik Sense has not such option. Would like to shift this thread in the ideas-forum. Do I have to post a new thread there? Didn't find out how to move it.