Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Adjust Labels on X and Y Axis - Qlik Sense Desktop

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 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

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

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

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

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

View solution in original post