topic Re: Bar Chart Vs Straight Table in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-Vs-Straight-Table/m-p/1505#M211 <HTML><HEAD></HEAD><BODY><P>Try using Sum(Aggr()) in your bar chart</P><P></P><P><STRONG>Sum(Aggr(If(Sum(Qty)&gt;Sum(Sales),Sum(Sales),Sum(Qty)), Division, Material))</STRONG></P></BODY></HTML> Tue, 16 Jan 2018 13:41:18 GMT sunny_talwar 2018-01-16T13:41:18Z Bar Chart Vs Straight Table https://community.qlik.com/t5/QlikView/Bar-Chart-Vs-Straight-Table/m-p/1504#M210 <HTML><HEAD></HEAD><BODY><P>Attached please find the sample xls and qvw.&nbsp; I have a Bar chart and straight table.&nbsp; The 2 metrics are Qty and Sales and we calculate a metrics called (Sales Vs Qty) using the below expression.</P><P></P><P>If(Sum(Qty)&gt;Sum(Sales),Sum(Sales),Sum(Qty))</P><P></P><P>The issue is that the Bar chart and straight table both are giving different result&nbsp; cuz the straight table is doing the comparison at the row level&nbsp; and bar chart at the hight level.&nbsp; The straight table number is correct and how can I make the Bar Chart to be the same as Straight table.</P></BODY></HTML> Tue, 16 Jan 2018 13:23:07 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Vs-Straight-Table/m-p/1504#M210 azmeerrehan 2018-01-16T13:23:07Z Re: Bar Chart Vs Straight Table https://community.qlik.com/t5/QlikView/Bar-Chart-Vs-Straight-Table/m-p/1505#M211 <HTML><HEAD></HEAD><BODY><P>Try using Sum(Aggr()) in your bar chart</P><P></P><P><STRONG>Sum(Aggr(If(Sum(Qty)&gt;Sum(Sales),Sum(Sales),Sum(Qty)), Division, Material))</STRONG></P></BODY></HTML> Tue, 16 Jan 2018 13:41:18 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Vs-Straight-Table/m-p/1505#M211 sunny_talwar 2018-01-16T13:41:18Z