6 Replies Latest reply: Jan 4, 2017 12:38 AM by Arpit Kharkia RSS

    Obtain field with maximum value

    Arpit Kharkia

      Please consider the following example:

       

      CategoryValue
      A10%
      B20%
      B22%
      A20%

       

      I will be loading the above table directly into Qlik. What I want is to first have an average of Value so that the following table is obtained:

       

      CategoryValue
      A15%
      B21%

       

       

      from this now I have to find the name of the category having the highest value. So, from table1 I have to obtain Category B as the answer.

      How to perform the above using Set Analysis or/and Back-end scripting?