Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
check this thread QlikView App: Dates, Date Ranges and Set Analysis