topic problem with accumulation syntax in QlikView https://community.qlik.com/t5/QlikView/problem-with-accumulation-syntax/m-p/105849#M16623 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am having trouble to get the accumulation set expression right. I am trying to accumulated <SPAN style="font-size: 13.3333px;">media_amount based selection of signed_date dimensions for months (which is again different dimension based on other date).&nbsp; So desired outcome would show all media_amount signed for that date and all previous signed dates. Originally I was triyng to solve this with filter that would be accumulative but found out that this is not the approach in qlik.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">rangesum( above( sum({&lt;signed_date = {"&lt;=$(Max(signed_date))"},Month= &gt;}[media_amount]),0,rowno(0)))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">It works almost fine if i use TOTAL keyword with rowno but the end result is accmulation across different dimension (which i need to use to display the results) which I dont want (the order of that dimension is meaningless as is the accumulation across it).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">The strangely similar expression below works fine. which propably means that the problem is not in fact table that has adhoc order.</SPAN></P><P><SPAN style="font-size: 13.3333px;"> </SPAN></P><P><SPAN style="font-size: 13.3333px;">=Rangesum(Above($(Sum({$&lt;FinYear&nbsp; = {"$(vLYFinYear)"},signed_date={"&lt;=$(vLYToday)"},Year=,Month=,Quarter=&gt;} [media_amount]),0,RowNo()))</SPAN></P><P></P><P>thank you any hel</P></BODY></HTML> Mon, 15 Oct 2018 20:48:40 GMT Anonymous 2018-10-15T20:48:40Z problem with accumulation syntax https://community.qlik.com/t5/QlikView/problem-with-accumulation-syntax/m-p/105849#M16623 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am having trouble to get the accumulation set expression right. I am trying to accumulated <SPAN style="font-size: 13.3333px;">media_amount based selection of signed_date dimensions for months (which is again different dimension based on other date).&nbsp; So desired outcome would show all media_amount signed for that date and all previous signed dates. Originally I was triyng to solve this with filter that would be accumulative but found out that this is not the approach in qlik.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">rangesum( above( sum({&lt;signed_date = {"&lt;=$(Max(signed_date))"},Month= &gt;}[media_amount]),0,rowno(0)))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">It works almost fine if i use TOTAL keyword with rowno but the end result is accmulation across different dimension (which i need to use to display the results) which I dont want (the order of that dimension is meaningless as is the accumulation across it).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">The strangely similar expression below works fine. which propably means that the problem is not in fact table that has adhoc order.</SPAN></P><P><SPAN style="font-size: 13.3333px;"> </SPAN></P><P><SPAN style="font-size: 13.3333px;">=Rangesum(Above($(Sum({$&lt;FinYear&nbsp; = {"$(vLYFinYear)"},signed_date={"&lt;=$(vLYToday)"},Year=,Month=,Quarter=&gt;} [media_amount]),0,RowNo()))</SPAN></P><P></P><P>thank you any hel</P></BODY></HTML> Mon, 15 Oct 2018 20:48:40 GMT https://community.qlik.com/t5/QlikView/problem-with-accumulation-syntax/m-p/105849#M16623 Anonymous 2018-10-15T20:48:40Z