topic Sum with distinct (other) column in QlikView https://community.qlik.com/t5/QlikView/Sum-with-distinct-other-column/m-p/266248#M100075 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I currently have a table that includes 3 columns:</P><P></P><P>- ProjectName</P><P>- OrderID (unique)</P><P>- OrderValue</P><P></P><P>I want to have a chart/table that shows the total value of each project. Normally it would just be a case of having the name as a dimension and sum(OrderValue) as an expression, but I noticed that there are duplicate OrderIDs as each stage of the order process generates multiple rows.</P><P></P><P>So, what would be needed to be done is first select all distinct OrderIDs and then sum up the corresponding OrderValues for those rows. I tried using the aggr() function as it seemed the most obvious route, but not with much success.</P></BODY></HTML> Thu, 11 Aug 2011 13:20:25 GMT 2011-08-11T13:20:25Z Sum with distinct (other) column https://community.qlik.com/t5/QlikView/Sum-with-distinct-other-column/m-p/266248#M100075 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I currently have a table that includes 3 columns:</P><P></P><P>- ProjectName</P><P>- OrderID (unique)</P><P>- OrderValue</P><P></P><P>I want to have a chart/table that shows the total value of each project. Normally it would just be a case of having the name as a dimension and sum(OrderValue) as an expression, but I noticed that there are duplicate OrderIDs as each stage of the order process generates multiple rows.</P><P></P><P>So, what would be needed to be done is first select all distinct OrderIDs and then sum up the corresponding OrderValues for those rows. I tried using the aggr() function as it seemed the most obvious route, but not with much success.</P></BODY></HTML> Thu, 11 Aug 2011 13:20:25 GMT https://community.qlik.com/t5/QlikView/Sum-with-distinct-other-column/m-p/266248#M100075 2011-08-11T13:20:25Z