topic Re: Tricky sum set analysis excercise in QlikView https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921307#M319158 <HTML><HEAD></HEAD><BODY><P>great, thank you!</P></BODY></HTML> Thu, 30 Jul 2015 12:33:29 GMT 2015-07-30T12:33:29Z Tricky sum set analysis excercise https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921305#M319156 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>need to find a way to sum as per the below example.</P><P>I guess some kind of set analyisis approach would be suitable but I cannot get it to work properly.</P><P>Pls see attached QV-example file and *expected result* excel file.</P><P></P><P>//O</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94525_Capture.JPG" style="width: 620px; height: 347px;" /></P></BODY></HTML> Thu, 30 Jul 2015 09:13:22 GMT https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921305#M319156 2015-07-30T09:13:22Z Re: Tricky sum set analysis excercise https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921306#M319157 <HTML><HEAD></HEAD><BODY><P>Expression for 1 Year:</P><P></P><P><EM>RangeSum(Below(</EM><BR /><EM>FABS((SUM({&lt;Type= {'1 year'}&gt;}Volume))*(1-Period*vPrepayment/4)</EM><BR /><EM>-</EM><BR /><EM>(SUM({&lt;Type= {'1 year'}&gt;}Volume)))</EM></P><P><EM>/Period</EM><BR /><EM>,1,Count(Distinct Total QYear)))</EM></P><P></P><P>Try similar for others</P><P></P><P>Edit: added 'Distinct'</P></BODY></HTML> Thu, 30 Jul 2015 09:26:04 GMT https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921306#M319157 tresB 2015-07-30T09:26:04Z Re: Tricky sum set analysis excercise https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921307#M319158 <HTML><HEAD></HEAD><BODY><P>great, thank you!</P></BODY></HTML> Thu, 30 Jul 2015 12:33:29 GMT https://community.qlik.com/t5/QlikView/Tricky-sum-set-analysis-excercise/m-p/921307#M319158 2015-07-30T12:33:29Z