Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with set analysis

I have forecast for 20 weeks in the future. I want a graph that only shows current week + 10 weeks. What set analysis could I use?

12 Replies
Not applicable
Author

I use this site when I have doubts about the Set Analysis

"http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx"

lironbaram
Partner - Master III
Partner - Master III

hi

have a look at the attach example

Not applicable
Author

Now if I had actual sales details from the past months... how can I incorporate that into this graph to show me 4 weeks of previous sales?

The problem that I'm having here is that, for sales.. there is no snapshot week. only calendar_week. The goal of this graph is to see 4 weeks of actual sales prior to current week and also see 12 weeks of future forecast data.

example: if the current week in the example is 9/1/2014. I want to see actual sales for 8/25/2014, 8/18/2014, 8/11/2014, 8/4/2014 and then I want to see future forecast from 9/1/2014 to 11/10/2014 ............see sample app