Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator
Creator

How to create rolling week sum of sales

Hi,

I have the attached data which I'm using in my data model (Week Field and Sales Field),  so now my requirement is I've to load data until current week in current year.

For example today is 09/21/2021 and week number is 38, so I'm looking for a set analysis expression to sum the sales until current week (from wk1 - wk38). Next week it has sum the sales until week 39 (from wk1 - wk39).

Along with that I'm looking for a line chart to load data until current week i.e. 38 as below.

vikasshana_0-1632228913979.png

 

0 Replies