Idea required - week between years

datanibbler — Tue, 21 Jan 2014 08:41:08 GMT

Hi all,

I am just trying to think of an idea to capture that "week_between_the_years" that we had this/last year and that we're having again next/this year:

- A part of the week is in Dec. of one year, in week 52

- A part of the week is in Jan. of the following year, in week 1

I just thought I'd share the way I have devised of doing this, maybe someone can come up with a better one.

I have so far devised a way of capturing that case, but I realize that it does only half the job:

- By using year(weekstart(today(), -1)) and week(weekstart(today, -1)), I can determine that the start of that week is not in this year, but in the last and that the nr. of that week is not (2-1), but 52.

<=> However, if I build that into a set_expression, because of the year_selection, it captures only those days which were effectively in the same year and week as the start of the week - so, taking last/this year as an example, it would have captured only Mo and Tue.

=> Easy enough, the remaining days could be captured by using year(weekend(today(), -1)) and week(weekend(today, -1)).

=> That would make the set_expression really complex as you'd have to actually use two different ones and build them into an

IF_construct querying first if weekstart is in a different year than weekend.

=> This is, however, the best I can think of.

If someone has a better idea, please share it.

Best regards,

DataNibbler

topic Idea required - week between years in QlikView

Idea required - week between years