I want to get the variance of 'Current Year Day of Week' Revenue and 'Previous Year same Day of Week' Revenue.
Ex:
Suppose today is 4th Sep 2014 and the week day is Thursday and the Revenue is 100$.
and the same week day(Thursday) in the previous year is fell on 5th Sep 2014 and the Revenue is 50$,
Now want to get the variance of these two values. How to do in Qlikview Please give me response ASAP.