Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
trishita
Contributor 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

4 Replies
Partner
Partner

Re: Showing percentage in pie for a specific dimenion

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
trishita
Contributor III

Re: Showing percentage in pie for a specific dimenion

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.
Partner
Partner

Re: Showing percentage in pie for a specific dimenion

Use this formula:

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

Is Pensioneinrichtung still the dimension? Or something else? 

Jordy

Climber

Work smarter, not harder
trishita
Contributor III

Re: Showing percentage in pie for a specific dimenion

not working