Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Moving 31-Day Sales with Week Number as a Dimension

Hi Guys!

I want to create a column chart with week number as a dimension and the measure of each would be each week's accumulated sales 31 days back. (e.g WK25 = Sum of May 20 until Jun 19 2016 Sales, WK24 = May 13 to Jun 12 2016 Sales, so on.)

I imagine it to be like this:

Moving 31 Day Sales.PNG

Is it attainable to insert a set analysis? or would it be better to code in the data load?

Thanks!

0 Replies