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!