Week this Year vs Week Last Year

[lylererger]

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]

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

http://community.qlik.com/search.jspa?q=current+vs+previous

- Marcus

[Anonymous · Accepted solution]

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.