Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator II
Creator II

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