2 Replies Latest reply: Dec 18, 2014 6:25 AM by Ali Haider RSS

    Range Average Qlikview

    Ali Haider

      I am trying to calculate a moving average for customers. I want my table to show me the average of each customer based on his previous months data available. When I make a selection of a particular customer the table works fine. But problem arises when there is no selection on Contract. The table does not aggregate the moving average w.r.t to Customers. The query that i am currently using, which works fine for each Contract when selected, is:

      Rangeavg(Above(TOTAL Sum(UnitBilled), 1, Rowno(TOTAL)))

       

      However when there is no selection made the table shows the following details:

      For each contract i want the table to show his own moving average. Like it is doing so for A in the above table.

      Thanks!