topic Show Percentage on chart in QlikView https://community.qlik.com/t5/QlikView/Show-Percentage-on-chart/m-p/119249#M750277 <HTML><HEAD></HEAD><BODY><P>Hi Guys I have the below chart.</P><P></P><P>The user want to add up all the totals below and devide into each total on the bars so for example adding these all up</P><P>746+717+536+529+196+126 =</P><P>2850</P><P></P><P>So for example for the 746 I should get a % of 26.1%</P><P></P><P>746/2850*100=26.1%&nbsp; I'm trying to get a expression for the calculation!</P><P></P><P>The Dimension is Time:CMHT Appt</P><P>and Expression is <SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NEWKEYID</SPAN><SPAN style="font-size: 8pt;">)-</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PatientsNotAssessed_ID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">I've tried a few just not getting right result</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Any Ideas</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Martin</SPAN></P><P></P><P></P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217855_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sweens78 2020-11-25T16:16:04Z Show Percentage on chart https://community.qlik.com/t5/QlikView/Show-Percentage-on-chart/m-p/119249#M750277 <HTML><HEAD></HEAD><BODY><P>Hi Guys I have the below chart.</P><P></P><P>The user want to add up all the totals below and devide into each total on the bars so for example adding these all up</P><P>746+717+536+529+196+126 =</P><P>2850</P><P></P><P>So for example for the 746 I should get a % of 26.1%</P><P></P><P>746/2850*100=26.1%&nbsp; I'm trying to get a expression for the calculation!</P><P></P><P>The Dimension is Time:CMHT Appt</P><P>and Expression is <SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NEWKEYID</SPAN><SPAN style="font-size: 8pt;">)-</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PatientsNotAssessed_ID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">I've tried a few just not getting right result</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Any Ideas</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Martin</SPAN></P><P></P><P></P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217855_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Show-Percentage-on-chart/m-p/119249#M750277 sweens78 2020-11-25T16:16:04Z Re: Show Percentage on chart https://community.qlik.com/t5/QlikView/Show-Percentage-on-chart/m-p/119250#M750278 <HTML><HEAD></HEAD><BODY><P>You could click the 'Relative' checkbox on the Chart Properties | Expressions tab.</P><P></P><P>Or something like:</P><P></P><P><EM>Count(NEWKEYID)-Count(PatientsNotAssessed_ID) </EM></P><P><EM>/</EM></P><P><EM>Sum(TOTAL Aggr(Count(NEWKEYID)-Count(PatientsNotAssessed_ID), </EM>Dim<EM>)</EM></P><P></P><P>Dim is the name of the chart dimension.</P></BODY></HTML> Thu, 08 Nov 2018 11:12:40 GMT https://community.qlik.com/t5/QlikView/Show-Percentage-on-chart/m-p/119250#M750278 jonathandienst 2018-11-08T11:12:40Z