Solved: Adjust Labels on X and Y Axis - Qlik Sense Desktop - Qlik Community

Report Inappropriate Content · ‎2016-01-06

I am trying to change the way labels are displayed.

1) How do you change decimals to percentages?

2) How do you display values in K or M? For example, how would I change 1,000,000.00 to display as 1,000K?

Thank you again for your help!

Gysbert_Wassenaar · ‎2016-01-06

1. Use the num function: num(sum(Sales)/sum(total Sales), '0.0%'

2. Qlik Sense does that automatically if you set the Number formatting option of the expression to Auto.

talk is cheap, supply exceeds demand

Gysbert_Wassenaar · ‎2016-01-06

1. Use the num function: num(sum(Sales)/sum(total Sales), '0.0%'

2. Qlik Sense does that automatically if you set the Number formatting option of the expression to Auto.

talk is cheap, supply exceeds demand

Adjust Labels on X and Y Axis - Qlik Sense Desktop