Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
chiranjivdas
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
shiveshsingh
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

chiranjivdas
Contributor III
Contributor III
Author

Thank you. This worked!