topic aggr,range sum functions with set analysis in QlikView https://community.qlik.com/t5/QlikView/aggr-range-sum-functions-with-set-analysis/m-p/979411#M334457 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>how do we write this if condition by using set anlysis</P><P>if(BS= 'P',sum( aggr( rangesum( above( sum([val]),0,12)),YearMonthNumber)))</P><P></P><P>Thanks in adavce</P></BODY></HTML> Mon, 24 Aug 2015 08:31:23 GMT grajmca_sgp123 2015-08-24T08:31:23Z aggr,range sum functions with set analysis https://community.qlik.com/t5/QlikView/aggr-range-sum-functions-with-set-analysis/m-p/979411#M334457 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>how do we write this if condition by using set anlysis</P><P>if(BS= 'P',sum( aggr( rangesum( above( sum([val]),0,12)),YearMonthNumber)))</P><P></P><P>Thanks in adavce</P></BODY></HTML> Mon, 24 Aug 2015 08:31:23 GMT https://community.qlik.com/t5/QlikView/aggr-range-sum-functions-with-set-analysis/m-p/979411#M334457 grajmca_sgp123 2015-08-24T08:31:23Z Re: aggr,range sum functions with set analysis https://community.qlik.com/t5/QlikView/aggr-range-sum-functions-with-set-analysis/m-p/979412#M334458 <HTML><HEAD></HEAD><BODY><P>If you had some more context to it I might be more sure if this is a correct solution - but I guess:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum( Aggr( RangeSum( Above( Sum( <STRONG>{ &lt; BS={'P'} &gt; }</STRONG> [val]) , 0 , 12 ) ) , YearMonthNumber ) )</SPAN></P></BODY></HTML> Mon, 24 Aug 2015 08:41:29 GMT https://community.qlik.com/t5/QlikView/aggr-range-sum-functions-with-set-analysis/m-p/979412#M334458 petter 2015-08-24T08:41:29Z