topic Week this Year vs Week Last Year in QlikView

Week this Year vs Week Last Year

lylererger — Fri, 27 Mar 2015 20:49:44 GMT

Hi all.

Would like to discuss a very interesting topic.

Objective - comparison of the two periods in terms of weeks.

For instance, in Year 2014 46 Week (17.11.2014 - 23.11.2014) will be compared with Year 2013 Week 46 (18.11.2013 - 24.11.2013).

The user applies the filter for the current year (2014) and Week (46).

I've got two variables which set the boundaries of the selected time range this year (17.11.2014 - 23.11.2014).

If I shift the boundaries of the selected time range on a year ago - I get (17.11.2013 - 23.11.2013).

Could you tell how to solve this question?

Thanks in advance.

marcus_sommer — Fri, 27 Mar 2015 21:16:51 GMT

Have a look on these postings which all compare a current period against a previous one:

- Marcus

Anonymous — Fri, 27 Mar 2015 21:28:44 GMT

I think that function makeweekdate() can help you. For example:

makeweekdate(Year(today())-1, 46)

will return Monday on the week 46 of the last year. And you can calculate the rest from there.