topic Re: How to write condition to find sum in QlikView https://community.qlik.com/t5/QlikView/How-to-write-condition-to-find-sum/m-p/1420363#M428596 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr([Story Points], Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Avg([Story Points]), Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Min([Story Points]), Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Max([Story Points]), Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Sum(DISTINCT [Story Points]), Story_Id))</STRONG></P></BODY></HTML> Tue, 24 Oct 2017 15:30:25 GMT sunny_talwar 2017-10-24T15:30:25Z How to write condition to find sum https://community.qlik.com/t5/QlikView/How-to-write-condition-to-find-sum/m-p/1420362#M428595 <HTML><HEAD></HEAD><BODY><P>I have 2 columns in a table<BR />1) StoryID&nbsp; and 2) StoryPoints</P><P></P><P>StoryID has 44 values out of which 28 values are distinct.</P><P>Now I want to find the sum of story points of all distinct StoryId's.</P><P>ie., sum(of StoryPoints (of <SPAN style="font-size: 13.3333px;">all distinct StoryID))</SPAN></P><P>because Sum of all Story Points = 258</P><P>and S<SPAN style="font-size: 13.3333px;">um(of StoryPoints (of </SPAN><SPAN style="font-size: 13.3333px;">all distinct StoryID)) = 166 [Which is desirable]</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Looking for help and suggestions.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks in advance</SPAN></P></BODY></HTML> Tue, 24 Oct 2017 08:28:46 GMT https://community.qlik.com/t5/QlikView/How-to-write-condition-to-find-sum/m-p/1420362#M428595 Anonymous 2017-10-24T08:28:46Z Re: How to write condition to find sum https://community.qlik.com/t5/QlikView/How-to-write-condition-to-find-sum/m-p/1420363#M428596 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr([Story Points], Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Avg([Story Points]), Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Min([Story Points]), Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Max([Story Points]), Story_Id))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Sum(DISTINCT [Story Points]), Story_Id))</STRONG></P></BODY></HTML> Tue, 24 Oct 2017 15:30:25 GMT https://community.qlik.com/t5/QlikView/How-to-write-condition-to-find-sum/m-p/1420363#M428596 sunny_talwar 2017-10-24T15:30:25Z