Discussion board where members can get started with Qlik Sense.
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
Try this function:
Count(Pensioneinrichtung) / Count(TOTAL Pensioneinrichtung)
And put this with the dimension Pensioneinrichtung in a measure.
Use this formula:
Count([HPV Buchwert]) / Count(TOTAL [HPV Buchwert])
Is Pensioneinrichtung still the dimension? Or something else?