Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
trishita
Contributor III

Problems in showing "other" shares in pie chart

 I am facing is that i cant show the other shares in pie chart which does not contain the share of HPK in my pie.But that is visible in my table chart.The code i used for pie chart generation is: 

Sum({$<Pensionseinrichtung = {'HPK'}>} [HPV Buchwert])
/
only(Sum(Total{$<Pensionseinrichtung = {'HPK'},Stichtag_HPV = {'31.12.2018'}>}[HPV Buchwert])).I plotted this vs Source Kasse. I also want to show the remaining percentage as others for eg (100-(1.94+5.09)=92%) in my pie chartpie chart.JPG