topic Re: Sum of Price Value in QlikView https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991253#M954428 <HTML><HEAD></HEAD><BODY><P>Maybe </P><P>=Sum( Aggr( Only(Price), ItemID))</P><P></P><P>But I would rather fix this in the data model, seems like you joined a table where a linked table might be better.</P></BODY></HTML> Thu, 26 Nov 2015 12:37:02 GMT swuehl 2015-11-26T12:37:02Z Sum of Price Value https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991251#M954426 <HTML><HEAD></HEAD><BODY><P>From below table i want to calculate sum(Price) for each unique ItemID price must come&nbsp; only once.</P><P></P><P>Means result will be sum(Price)=80 not 170</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">ItemID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Price</SPAN></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P></BODY></HTML> Thu, 26 Nov 2015 12:32:35 GMT https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991251#M954426 prajapatiamar38 2015-11-26T12:32:35Z Re: Sum of Price Value https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991252#M954427 <HTML><HEAD></HEAD><BODY><P>=Sum(Aggr(Only(Price), ItemID))</P></BODY></HTML> Thu, 26 Nov 2015 12:36:21 GMT https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991252#M954427 jonathandienst 2015-11-26T12:36:21Z Re: Sum of Price Value https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991253#M954428 <HTML><HEAD></HEAD><BODY><P>Maybe </P><P>=Sum( Aggr( Only(Price), ItemID))</P><P></P><P>But I would rather fix this in the data model, seems like you joined a table where a linked table might be better.</P></BODY></HTML> Thu, 26 Nov 2015 12:37:02 GMT https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991253#M954428 swuehl 2015-11-26T12:37:02Z Re: Sum of Price Value https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991254#M954429 <HTML><HEAD></HEAD><BODY><P>may be:</P><P></P><P>Take ITemID as a Dimension</P><P></P><P>Expression:&nbsp; sum(&lt;total ITemID&gt; Price) </P></BODY></HTML> Thu, 26 Nov 2015 12:48:16 GMT https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991254#M954429 Anonymous 2015-11-26T12:48:16Z Re: Sum of Price Value https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991255#M954430 <HTML><HEAD></HEAD><BODY><P>Thanx to all guys</P></BODY></HTML> Mon, 07 Dec 2015 11:41:28 GMT https://community.qlik.com/t5/QlikView/Sum-of-Price-Value/m-p/991255#M954430 prajapatiamar38 2015-12-07T11:41:28Z