11 Replies Latest reply: Dec 12, 2017 10:32 PM by Jino Kannen RSS

    Compare different fields of rows and sum up the values

    Jino Kannen

      As it given in the excel sheet and the last column Partnership, i need the sum of scores if the pairs of striker and non striker are same.

       

      example Gayle - Uthappa is 27 and Uthappa - Gayle is 24, so the partnership is 2 +24 = 51.

       

      Please help how to solve in qlik sense. Thanks in advance!!