Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.