4 Replies Latest reply: Feb 13, 2017 10:46 AM by Fariha Tasneem Khan RSS

    Selective Average

    Fariha Tasneem Khan

      Hi,

       

      I am quite new to Qlik Sense and require some expert help regarding the following situation. Is there any expression that I can use to calculate the average of a selected datapoint? For instance if you consider the table below:

       

      TypeCount
      Apples100
      Pears20
      Apples 130
      Pineapple40
      Orange20

       

      From this table if I want to calculate only the average of "apples" then how do I do it? I require this for a chart function where I need to show the average count of a specific field by days.

       

      Any help in this regard is much appreciated.

       

      Best regards,

      Fariha