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

    Using set analysis for point in time reporting

    Peter Thornton

      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)/



      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,