Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Change Standard NumberFormat

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.

2019.1118-150019.jpg

Labels (1)
4 Replies
Highlighted
Creator II
Creator II

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!

Highlighted
Creator III
Creator III

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?

Highlighted
Creator II
Creator II

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. 

Highlighted
Creator III
Creator III

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.