7 Replies Latest reply: Jan 26, 2016 12:50 PM by Sunny Talwar RSS

    Create an average of current month and previous month in same column.

      I’m trying to create a measure that is the average of the current month and the previous month.   For example: if the sum(Sales) for Oct2015 is $1,000 and the sum(Sales) for Nov2015 is $2,000, I want value in this new column to be $1,500 for Nov2015. Likewise, the values in this column for the previous month, October, will be the average of Oct/Sep…and the value for the September row will be avg(Sep/Aug), etc.

       

      Is there a formula for Qliksense that will allow me to create this dimension in the table?  Might it have to be done in the script?  If so, how?

       

      Thanks,   Dan