Sum Field based on other two fields aggregated

FelipeG — Tue, 28 Dec 2021 19:56:59 GMT

Hello Qlik community !!

I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount.

My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity "Company" based on the Sum of the total amount, whether they acted as buyer or seller.

For example supposing I have this values in my Table:

Table:

[ Date, Buyer, Seller, Total Amount

12/05/2020, Apple, Amazon, 2000

13/05/2019, Amazon, Apple 2500

01/01/2020, Apple, Microsoft, 1000

]

I want a table-chart that displays: (Rank, Company, TotalAmountTransactioned)

1 - Apple - 5500

2 - Amazon - 4500

3 - Microsoft -1000

Will really appreciate it if someone can help me 🙂

Re: Sum Field based on other two fields aggregated

Kushal_Chawda — Sun, 20 Sep 2020 21:59:30 GMT

@FelipeG is below same thread?

https://community.qlik.com/t5/New-to-Qlik-Sense/Sum-Field-based-on-other-two-fields-aggregated/td-p/1745428

topic Sum Field based on other two fields aggregated in Connectivity & Data Prep

Sum Field based on other two fields aggregated

Re: Sum Field based on other two fields aggregated