Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
lylererger
Creator II
Creator II

Week this Year vs Week Last Year

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.


1 Solution

Accepted Solutions
mov
Employee
Employee

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.

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

mov
Employee
Employee

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.