topic Re: Week selection with different week start date in QlikView

Week selection with different week start date

Mon, 04 Aug 2014 16:45:45 GMT

I needed my week to start on a Saturday and end on a Friday. Meaning wk31 for me would start on Saturday 26/07/14 and end on Friday 01/08/14.

To achieve this I have created a listbox with the below expression instead of a field.

=week(WeekStart(Date,0,-2))+1

Not sure if this was the proper way of doing it but it seems to work.

Now I need to create a button which when pressed select the last 12 weeks according to my week format starting on Saturdays and ending Friday's.

I tried the below but this is creating a rolling range day by day.

='>=$(=date(today()-84))' & '<$(=date(today()))'

I need the range to start from Saturday of 13 weeks ago and end always Friday of last week. Anyone can help me get this please?

Re: Week selection with different week start date

ssanchez — Mon, 04 Aug 2014 22:13:24 GMT

Hi Alex,

In a similar case, I used a new field added to the master calendar in the load script. For each possible date, sorted in ascending order, I added a week personnel identifier value which is incremented for each starting day of week found (Saturday).

The new field can be selected from a button which selects date as possible values of the period of week (Saturday-Friday) or weeks required. The attachment shows an example.

Re: Week selection with different week start date

nagaiank — Mon, 04 Aug 2014 23:16:12 GMT

To arrive at the week start date (of Saturday-to-Friday week) for any Date, use the following expression:

Date(WeekStart(Date+2)-2)

Re: Week selection with different week start date

ashfaq_haseeb — Tue, 05 Aug 2014 05:27:18 GMT

Hi,

try below

If(WeekDay(Date) >= 5, Week(Date) +1, Week(Date)) AS NewWeek,

Regards

AHFAQ

Re: Week selection with different week start date

Tue, 05 Aug 2014 05:33:47 GMT

Hi,

You may try this

>=date((WeekStart(today(),-13)-2),'DD/MM/YYYY') <= date(WeekStart(today())-3,'DD/MM/YYYY')