This content has been marked as final. Show 2 replies
Hello everyone! I'm fairly new to Qlik Sense. I need to do the following:
I have two tables, Risk and Revenue.
|Serial No||Supplier Name||Risk Score|
The unique id in this table is the supplier name
|Serial No.||Product||Supplier Name||Revenue|
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.