topic Re: Re: Help with set analysis in QlikView

Help with set analysis

Tue, 30 Sep 2014 17:04:17 GMT

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?

Re: Help with set analysis

JonnyPoole — Tue, 30 Sep 2014 17:07:52 GMT

If you have a sample QVW that would help.

Re: Re: Help with set analysis

Tue, 30 Sep 2014 17:14:49 GMT

Here is a similar app that I've used from earlier.

Re: Help with set analysis

jyothish8807 — Tue, 30 Sep 2014 17:21:29 GMT

Hi Qlik,

Since your dated are already splitted into week so simply take current Date and Current date +10.It will give the out pot.Use set analysis.

Regards

Re: Help with set analysis

maxgro — Tue, 30 Sep 2014 17:34:59 GMT

maybe this

Sum({$ <Week={">=$(=week(Today()))<=$(=week(Today())+10)"},Year={$(=Year(today()))}>} [Forecast 1])

Re: Re: Re: Help with set analysis

Anonymous — Tue, 30 Sep 2014 17:37:08 GMT

Hello!

You can find attached the modifications that I did in your app. I think this solve your problem.

Regards,

Gabriel

Re: Help with set analysis

Tue, 30 Sep 2014 18:00:13 GMT

Thanks everyone for their contribution.

Sum({$ <Week={">=$(=week(Today()))<=$(=week(Today())+10)"},Year={$(=Year(today()))}>} [Forecast 1])

This seems to be the most suitable solution BUT whenever I choose a calendar_week, it says 'no data to display'

Look at this new application. It has the 'snapshot week'. Is there anyway to say, look at the Snapshot week, and display the data for calendar week for 10 weeks.

So if the snapshot week is 9/1/2014, then I want to display the calendar week 9/1/2014 - 11/3/2014 data in the graph....

Re: Help with set analysis

maxgro — Tue, 30 Sep 2014 18:22:21 GMT

if you don't want to consider the selection in calendar_week add bold

Sum({$ <calendar_week=, Week={">=$(=week(Today()))<=$(=week(Today())+10)"},Year={$(=Year(today()))}>} [Forecast 1])

Re: Help with set analysis

maxgro — Tue, 30 Sep 2014 18:27:39 GMT

Sum({$ <Week={">=$(=week(max([Snapshot Week])))<=$(=week(max([Snapshot Week]))+10)"}>} [Forecast 1])

get rid of calendar_week, add

calendar_week=

in set analysis

field1=

means remove the selection in field1

8/31/2015

if you want the currenti year add

Year={$(=Year(max([Snapshot Week])))}>}

Sum({$ <

calendar_week=,

Week={">=$(=week(max([Snapshot Week])))<=$(=week(max([Snapshot Week]))+10)"},

Year={$(=Year(max([Snapshot Week])))}>}

[Forecast 1])

Re: Help with set analysis

Tue, 30 Sep 2014 18:40:42 GMT

This still considers the selection in calendar_week ......and it also shows the last date available 8/31/2015. Any way to get rid of that?

Re: Help with set analysis

Tue, 30 Sep 2014 18:47:10 GMT

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

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

Re: Re: Help with set analysis

lironbaram — Tue, 30 Sep 2014 19:04:20 GMT

have a look at the attach example

Re: Re: Help with set analysis

Tue, 30 Sep 2014 21:48:43 GMT

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