topic Bar chart in QlikView https://community.qlik.com/t5/QlikView/Bar-chart/m-p/679154#M1079933 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Thank you all for your help in advance</P><P></P><P>I am using calculated dimension to exclude some categories from the field and now what I am trying to do it to calculate the percentage on whole rather than on filtered data</P><P></P><P>Here is the expression used to calculate </P><P></P><P>Count([TRANSACTION ID])/Count(TOTAL&lt;ZONE&gt; [TRANSACTION ID])</P><P></P><P>In chart 2 in attached QV I want to calculate the percentage on whole .So Zone A ,Product A2 = 60% and Product A3=&nbsp; 20%.</P><P></P><P>Can anyone please help me on this</P></BODY></HTML> Tue, 15 Jul 2014 14:23:11 GMT 2014-07-15T14:23:11Z Bar chart https://community.qlik.com/t5/QlikView/Bar-chart/m-p/679154#M1079933 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Thank you all for your help in advance</P><P></P><P>I am using calculated dimension to exclude some categories from the field and now what I am trying to do it to calculate the percentage on whole rather than on filtered data</P><P></P><P>Here is the expression used to calculate </P><P></P><P>Count([TRANSACTION ID])/Count(TOTAL&lt;ZONE&gt; [TRANSACTION ID])</P><P></P><P>In chart 2 in attached QV I want to calculate the percentage on whole .So Zone A ,Product A2 = 60% and Product A3=&nbsp; 20%.</P><P></P><P>Can anyone please help me on this</P></BODY></HTML> Tue, 15 Jul 2014 14:23:11 GMT https://community.qlik.com/t5/QlikView/Bar-chart/m-p/679154#M1079933 2014-07-15T14:23:11Z Re: Bar chart https://community.qlik.com/t5/QlikView/Bar-chart/m-p/679155#M1079934 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Please find in attachment a solution.</P><P></P><P>You don't need to filter product in dimension part, it's inside the expression.</P><P></P><P>Regards,</P><P></P><P>Laura</P></BODY></HTML> Tue, 15 Jul 2014 14:33:44 GMT https://community.qlik.com/t5/QlikView/Bar-chart/m-p/679155#M1079934 2014-07-15T14:33:44Z