Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to convert bar chart that has numbers to percentages?

Have the following values that I have created into a bar chart

CountryHeadcount
US15
France11
UK8
India21
Germany4
Sweden3

But want to convert the chart into percentage, meaning:

CountryHeadcount
US24%
France18%
UK13%
India34%
Germany6%
Sweden5%

Please help.

Thanks.

2 Replies
Highlighted
Master
Master

Your expression - sum(Headcount)/sum(TOTAL(Headcount))

then go to number tab, and select as shown in screenshotCapture.JPG

Your required result.

Capture.JPG

Highlighted
Contributor III
Contributor III

Thank you. This worked!