Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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