0 Replies Latest reply: Sep 5, 2014 12:46 AM by sreenu k RSS

    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 ye

    sreenu k

      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.