5 Replies Latest reply: Apr 17, 2016 10:17 PM by Srikanth P RSS

    How to find Avg and Max of a calculated field in QlikSense?

    Nikita Naresh

      I have a table as follows

           

      DateNameDenominatorCategoryScore
      SepA50332None3102
      SepA50332Min2416
      NovA47030Medium2338
      NovA47030Max1710
      SepB43792None629
      SepB43792Min567
      SepB43792Max552
      MarC33036None434
      MarC33036Min497
      MarC33036Medium529
      MarC33036Max890
      AprC39322None841
      AprC39322Min1493
      AprC39322Medium1702
      AprC39322Max1521

      This is the result of a crosstable since my categories were previously different columns in my source file. That's why the denominator, date, and name are duplicated across rows.

       

      I have calculated a field in my script  - ((Score)/(denominator)) *100as Rate_Calculated so that a rate is calculated in every row. On the front end, I do sum(Rate_calculated)/count(distinct Date) to get the averge rate for each name.

       

      How can I find the average Rate calculated for all Names across dates and categories? Also, how can I find the largest and smallest rates?

       

      I've tried Avg(Total Rate_calculated), sum({<Name=>}Rate_Calculated)/count(distinct Date) but they don't seem to work.

       

      Need this urgently, so appreciate any help!