topic How to create a cumulative rolling 52 week total using a flag in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134676#M462634 <HTML><HEAD></HEAD><BODY><P>A developer created a flag for us to use in set analysis for Rolling 52 Weeks, i.e. [Rolling 52 Weeks Flag], where it's either 'Y' or 'N'.&nbsp; I'm trying to figure out how display cumulative sales total for a given week (week's total sales + previous 51 weeks total sales), but can't seem to figure it out.&nbsp; Help!</P></BODY></HTML> Fri, 02 Sep 2016 00:11:39 GMT 2016-09-02T00:11:39Z How to create a cumulative rolling 52 week total using a flag https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134676#M462634 <HTML><HEAD></HEAD><BODY><P>A developer created a flag for us to use in set analysis for Rolling 52 Weeks, i.e. [Rolling 52 Weeks Flag], where it's either 'Y' or 'N'.&nbsp; I'm trying to figure out how display cumulative sales total for a given week (week's total sales + previous 51 weeks total sales), but can't seem to figure it out.&nbsp; Help!</P></BODY></HTML> Fri, 02 Sep 2016 00:11:39 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134676#M462634 2016-09-02T00:11:39Z Re: How to create a cumulative rolling 52 week total using a flag https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134677#M462635 <HTML><HEAD></HEAD><BODY><P>Why not simple option Cumulative and Accumulative. </P></BODY></HTML> Fri, 02 Sep 2016 02:40:54 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134677#M462635 Anil_Babu_Samineni 2016-09-02T02:40:54Z Re: How to create a cumulative rolling 52 week total using a flag https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134678#M462636 <HTML><HEAD></HEAD><BODY><P>Thanks Anil.&nbsp; I'm fairly new to Qlik Sense.&nbsp; Could you please explain?</P></BODY></HTML> Fri, 02 Sep 2016 15:56:44 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-cumulative-rolling-52-week-total-using-a-flag/m-p/1134678#M462636 2016-09-02T15:56:44Z