topic Re: How to display data for 9 weeks ago until current week in QlikView

How to display data for 9 weeks ago until current week

benjamins — Fri, 04 Jul 2014 13:10:23 GMT

I'm trying to create a bar diagram with exactly ten bars. Each bar should display data, the first one from 9 weeks ago, the last one from the current week.

I've experimented around with set analysis but to no avail.

Any help appreciated!

Re: How to display data for 9 weeks ago until current week

Gysbert_Wassenaar — Fri, 04 Jul 2014 14:02:04 GMT

It really depends on your data. Can you post a small example document with some data? See this document for how to do that safely: Preparing examples for Upload - Reduction and Data Scrambling

Re: Re: How to display data for 9 weeks ago until current week

benjamins — Mon, 07 Jul 2014 07:34:33 GMT

I see!

Attached you find a sample.

My goal is to have the diagramm show exactly ten bars - the last being this week and the first nine weeks ago.

Re: How to display data for 9 weeks ago until current week

ThornOfCrowns — Mon, 07 Jul 2014 08:52:31 GMT

Change your first dimension to:

=if(DateId>=Today()-63 and DateId <=Today()-0,YearWeek)

and set the "Supress when value is Null" tickbox

Re: Re: Re: How to display data for 9 weeks ago until current week

ashfaq_haseeb — Mon, 07 Jul 2014 08:53:19 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: How to display data for 9 weeks ago until current week

benjamins — Mon, 07 Jul 2014 09:00:10 GMT

Not bad, but there are two issues with this solution:

1.) Categories have to be selected (even though I don't get why).

2.) The last one isn't the current week, but the last week for which there is data. While in theory this should be the current week, this isn't the case in the real world. Example: A ship is estimated to arrive in three days, but is already there, the data would be counted as punctual and thus would ruin the chart.

Re: How to display data for 9 weeks ago until current week

benjamins — Mon, 07 Jul 2014 09:00:58 GMT

This was my initial thought as well. On a Monday this is correct. But on any other day the first week is incomplete.

Re: How to display data for 9 weeks ago until current week

ashfaq_haseeb — Mon, 07 Jul 2014 09:06:37 GMT

Hi,

1) as you don't have data for max week which is 2014 52 that's the reason its not showing you result.

If you have data you will get proper result.

2) you can create a variable vmaxWeek =if(len(week(today()))=1,0&week(today()),week(today()))

Now use variables instead of max function i use.

Hope it helped

Regards

ASHFAQ

Re: How to display data for 9 weeks ago until current week

benjamins — Mon, 07 Jul 2014 09:24:31 GMT

Absolutely!

Thank you so much!

Re: Re: How to display data for 9 weeks ago until current week

benjamins — Tue, 08 Jul 2014 07:30:49 GMT

Sorry to bother once more, but when I implemented this solution in my project I noticed the >=vcurrentWeek-9 does not seem to work (see attached sample).

Re: Re: Re: How to display data for 9 weeks ago until current week

ashfaq_haseeb — Tue, 08 Jul 2014 08:34:31 GMT

Hi,

Look at the attached document.

Regards

ASHFAQ

Re: Re: Re: How to display data for 9 weeks ago until current week

benjamins — Tue, 08 Jul 2014 08:52:43 GMT

Works!