Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

Can we have option to display the numbers to 1 decimal places, while the measure format is set to Auto

HI All,

Can we have option to display the measure to 1 decimal places, while the measure format is set to Auto.

As currently Qlik automatically shows the measure decimal points based on data for eg in some chart  measure is showing value upto 1 decimal point (10.12M) and in other chart its showing upto 2 decimal point (15.1M), So to make dashboard consistent this option will be really helpful.

So if there is option to show measure value upto 1 decimal point dashboard will be more consistent means both chart will show values like 10.1 M and 15.1 M respectively.

2 Replies
Qlik1_User1
Specialist
Specialist
Author

Kindly help on this please.

StarinieriG
Partner - Specialist
Partner - Specialist

Hello,

try something like this Round(EXPR/1000000,0.1)*1000000