Weekday Comparison

[EvaHuang]

Hi,

How to compare current month with the same month last year, by date format and the equal weekday?

For example, 2015/1/1 compared with 2014/1/2 , because they all are Thursday.

And so on, 2015/1/31 want to compare with 2014/1/1 not related weekday but the same month.

The table should look like below:

Date          Comparison Date

2015/1/1    2014/1/2

2015/1/2    2014/1/3

   ：                  ：

2015/1/30  2014/1/31

2015/1/31  2014/1/1

Thank you.

[ramoncova06]

check this thread QlikView App: Dates, Date Ranges and Set Analysis