I want to get the variance of 'Current Year Day of Week' Revenue and 'Previous Year same Day of Week' Revenue.
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 onand the Revenue is 50$,
Now want to get the variance of these two values. How to do in Qlikview Please give me response ASAP.