Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Showing percentage in pie for a specific dimenion

I want to show the value of the Pesnionscheme=HPK for both HPPD and HPPI-K in the pie chart.

For example I want to show the  HPV Buchwert share  of HPK  (1192 out 6076) for HPPIK ( 2994 out 6076) 

which means want to show the share of Column 2 for HPK  /Total  value of Column 2 where Column 2 is HPV Buchwert 

 

 

pie chart.JPG

Labels (4)
4 Replies
Highlighted
Partner
Partner

Hi Tri**bleep**a,

Try this function:

Count(Pensioneinrichtung) / Count(TOTAL Pensioneinrichtung)

And put this with the dimension Pensioneinrichtung in a measure.

Jordy

Climber

Work smarter, not harder
Creator III
Creator III

well i want to show the percentage for the second column HPV Buchwert not Pensioneinrichtung.
And HPV Buchwert is the quantity shown in the second column.
Highlighted
Partner
Partner

Use this formula:

Count([HPV Buchwert]) / Count(TOTAL [HPV Buchwert])

Is Pensioneinrichtung still the dimension? Or something else? 

Jordy

Climber

Work smarter, not harder
Highlighted
Creator III
Creator III

not working