topic Re: Expression for Total in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655352#M1072827 <HTML><HEAD></HEAD><BODY><P>Have you tried something like:</P><P></P><P>=SUM(AGGR(SUM(SUM([Quantity]) * [Price]),[ProdName]))</P><P></P><P>This will work if your product is always sold at the same price. If the price can vary you want to add in a dimension with appropriate granularity, something like:</P><P>=SUM(AGGR(SUM([Quantity] * [Price]),[ProdName],[Order#]))</P></BODY></HTML> Mon, 11 Aug 2014 18:07:21 GMT 2014-08-11T18:07:21Z Expression for Total in Set Analysis https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655349#M1072824 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to find the total value of the expression (Quantity * Price) and display it in the Gauge-LED chart. What would be the expression to do so ? Please find attached.</P><P>Thanks in advance</P><P></P><P>Regards</P><P>Umar</P></BODY></HTML> Mon, 11 Aug 2014 10:04:10 GMT https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655349#M1072824 umartareen 2014-08-11T10:04:10Z Re: Expression for Total in Set Analysis https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655350#M1072825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below</P><P>sum(Total <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Quantity * Price)</SPAN></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 11 Aug 2014 10:06:13 GMT https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655350#M1072825 ashfaq_haseeb 2014-08-11T10:06:13Z Re: Expression for Total in Set Analysis https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655351#M1072826 <HTML><HEAD></HEAD><BODY><P>Thank You Ashfaq, but it still didn't produce the output.</P></BODY></HTML> Mon, 11 Aug 2014 16:56:35 GMT https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655351#M1072826 umartareen 2014-08-11T16:56:35Z Re: Expression for Total in Set Analysis https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655352#M1072827 <HTML><HEAD></HEAD><BODY><P>Have you tried something like:</P><P></P><P>=SUM(AGGR(SUM(SUM([Quantity]) * [Price]),[ProdName]))</P><P></P><P>This will work if your product is always sold at the same price. If the price can vary you want to add in a dimension with appropriate granularity, something like:</P><P>=SUM(AGGR(SUM([Quantity] * [Price]),[ProdName],[Order#]))</P></BODY></HTML> Mon, 11 Aug 2014 18:07:21 GMT https://community.qlik.com/t5/QlikView/Expression-for-Total-in-Set-Analysis/m-p/655352#M1072827 2014-08-11T18:07:21Z