Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this, If this is in KPI? PFA
=Money(Sum({<[Risk Score] = {">5"}>} Revenue),'$#,##0')
Try this, If this is in KPI? PFA
=Money(Sum({<[Risk Score] = {">5"}>} Revenue),'$#,##0')
Yes, this is for a KPI.
Thanks Anil, this works. Appreciate it.