Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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.
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
Creator III
Creator III

not working