topic Re: rolling da in QlikView https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420236#M811011 <HTML><HEAD></HEAD><BODY><P>Use Above() function here</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179053_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 09 Oct 2017 15:29:36 GMT sunny_talwar 2017-10-09T15:29:36Z rolling da https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420235#M811010 <HTML><HEAD></HEAD><BODY><P>i have a&nbsp; straight table with month,year as dimension and sum(sales) as expression i want to create a rolling data like </P><P></P><P>Load * inline [year,month,sales</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,jan,100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,feb,100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,mar,100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,apr,100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,jun,100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,ju;ly,100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,aug,100]</P><P>output:</P><P style="font-size: 13.3333px;">year,month,sales,rollling month,rolling sales</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,jan,100,</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,feb,100,</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,mar,100,</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,apr,100, jan,100</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,jun,100,feb,200</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,ju;ly,100,mar,300</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000,aug,100,apr,400</P><P style="font-size: 13.3333px;">how can i get the rolling data like this please suggest me </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420235#M811010 manoj217 2020-11-25T16:16:04Z Re: rolling da https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420236#M811011 <HTML><HEAD></HEAD><BODY><P>Use Above() function here</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179053_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 09 Oct 2017 15:29:36 GMT https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420236#M811011 sunny_talwar 2017-10-09T15:29:36Z Re: rolling da https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420237#M811012 <HTML><HEAD></HEAD><BODY><P>Change the second expression to this</P><P></P><P><STRONG>=RangeSum(Above(Sum(sales), 3, RowNo()))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179057_Capture.PNG" style="height: 386px; width: 620px;" /></P></BODY></HTML> Mon, 09 Oct 2017 15:33:18 GMT https://community.qlik.com/t5/QlikView/rolling-da/m-p/1420237#M811012 sunny_talwar 2017-10-09T15:33:18Z