Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

Default Number Formatting in Chart Measures

Hi all,
I've been asked from a customer if it is possible to change the default options for the Number Formatting in any chart's Measures: e.g. when adding a Measure it defaults to Auto and then when switching to Number it defaults to '1.000,12'.

Would it be possible to change this to '1.000' ?

 

number_formatting.png

4 Replies
ashok_rajm
New Contributor III

Re: Default Number Formatting in Chart Measures

Hi, 

yes you can change it, there are two options:

Directly using number function in your measure Num() 

or

Use the custom formatting in the number format drop-down and change the format pattern.

Capture2.PNG

Partner
Partner

Re: Default Number Formatting in Chart Measures

Hi Ashok,
that is not applicable, I'd need to replace the default values that appear in the default dropdown to make sure that every time that a measure is added and set as Numeric format, then the first option available is '1.000'.

The customer knows about the Num(...)  in the Measure formula but that wouldn't be the best option for non-technical end users in case of custom made formulas.

ashok_rajm
New Contributor III

Re: Default Number Formatting in Chart Measures

I Don't think so you can achieve that, because even in System variables we don't have option to change the number format.
Ref: https://community.qlik.com/t5/New-to-QlikView/List-of-system-variables/td-p/465993
Partner
Partner

Re: Default Number Formatting in Chart Measures

Too bad, this applies to QlikView though and not Qlik Sense.