Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

showing percentage in a chart

please see screenshot will show exactly the request bij sample

thanks

 

2 Solutions

Accepted Solutions
edwin
Master II
Master II

try the expression 

=sum(MutbeDragFab)/sum(TOTAL MutbeDragFab)

this gives you the percentage for each
then in dimension limits set top 10.

in my example, the first chart shows the percentage for all (totals 100%), i set to top 5 dimension limits  in second chart (you can turn Others off/on):

edwin_0-1609172693889.png

 

View solution in original post

edwin
Master II
Master II

actually, you shouldnt.  in NUMBER tab, set it as percentage.

View solution in original post

5 Replies
edwin
Master II
Master II

try the expression 

=sum(MutbeDragFab)/sum(TOTAL MutbeDragFab)

this gives you the percentage for each
then in dimension limits set top 10.

in my example, the first chart shows the percentage for all (totals 100%), i set to top 5 dimension limits  in second chart (you can turn Others off/on):

edwin_0-1609172693889.png

 

JACKNIEKERK
Creator
Creator
Author

Thanks , only added this : *100

=(sum(MutBedragFak)/sum(TOTAL MutBedragFak))*100    works ok

edwin
Master II
Master II

actually, you shouldnt.  in NUMBER tab, set it as percentage.

JACKNIEKERK
Creator
Creator
Author

Ok, makes sence , thanks

 

edwin
Master II
Master II

yw