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!!

[kaanerisen]

Check my previous post if you don't want to see any duplicate mutual pairs. You should tagged the records as one pair like 'Gayle-Kohli' and 'Kohli-Gayle' records should be tagged as 'Kohli-Gayle' as pair. So there is no way that field has duplicate records.

You can try the script in my previous post to see if it works for you

[jino_kannen]

thanks kaanerisen‌ ..it worked well as it required. Thanks both of you!! (@omar)