11 Replies Latest reply: Aug 20, 2018 10:04 AM by Sunny Talwar RSS

    Average on count of the whole loaded data

    Karen Gumerov

      Hi. I'm trying to calculate average value on count of a field so that it would take the whole loaded data.

      For example, I need to take average on count of sales by date. This works fine unless I apply filters:


      Avg(Aggr(Count(sales), date))


      If I apply filtering, the average will be recalculated, but I need it to be constant among the whole data. So I tried using


      Avg(ALL Aggr(Count(sales), date))


      But it didn't work. Is that possible at all in QlikSense without primary grouping on query level?


      Any help is highly appreciated.

      Thanks in advance!