Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
EvaHuang
Partner - Contributor II
Partner - Contributor II

Weekday Comparison

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.

1 Reply
ramoncova06
Partner - Specialist III
Partner - Specialist III