9 Replies Latest reply: Jul 25, 2011 10:44 AM by chrispfeiffer RSS

    Cumulative Average Calculations

      Hi - as you may guess from this, I am very new to QlikView but need to get something out very fast! I have some raw data which contains details of customers and their spend by date. Each date also sits within a month and month is the dimension I'm using in this instance. I have created three expressions which show me, by month, the count of customers, the total spend and the average spend.

       

      I now need to show the cumulative average spend but am having difficulties! The accumulation options don't pull back the correct figures. Will this require a complex new expression or is there an easier was to resolve this?

       

      Thanks