How to aggregate values of one table based on values of another table?

[Anonymous]

Hello everyone! I'm fairly new to Qlik Sense. I need to do the following:

I have two tables, Risk and Revenue.

Risk:

Serial No	Supplier Name	Risk Score
1	A	8
2	B	4
3	C	10
4	D	2

The unique id in this table is the supplier name

Revenue:

Serial No.	Product	Supplier Name	Revenue
1	123	A	$10
2	234	A	$20
3	156	D	$1

The unique id in this table is the product number. But the tables are linked by the supplier name.

I want to calculate a KPI of sum of revenue for all products whose supplier has a risk score greater than 5.

The logic I am using is if([Risk Score] > 5, Sum([Revenue]))

I am not getting any answer from my code. The correct answer in this case should be $30 dollars.

Any pointers is greatly appreciated.

Best,

Pranab

[Anil_Babu_Samineni · Accepted solution]

Try this, If this is in KPI? PFA

=Money(Sum({<[Risk Score] = {">5"}>} Revenue),'$#,##0')

[Anonymous]

Yes, this is for a KPI.

Thanks Anil, this works. Appreciate it.