7 Replies Latest reply: Jun 26, 2014 9:49 AM by Peter Thornton RSS

    Using set analysis for point in time reporting

      I've got a copy of QlikView 11 for Developers and I've made use of a formula that they suggest for calculating month on month performance. I've edited it slightly so that it reflects the dimensions that I have within my QVDs so it now shows:

       

      =((Sum({$<PeriodID={"<=$(=Max(PeriodID-1))"},year=, quarter=,month=,period=>}customer_gross_sales)/

      Sum({$<PeriodID={"<=$(=Max(PeriodID-2))"},year=,quarter=,month=,period=>}customer_gross_sales)))-1

       

      This nearly works but it gives a percentage that is 100% out e.g. it shows 19510% growth for one product when it should be 19410%.

       

      I assume that it is ignoring the -1 at the end of the formula.

       

      Can anyone tell me why, or help me correct the formula?

       

      Thanks in advance,

       

      Peter