Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am beginner in Qlik. I have few KPIs in my sheet and 3 fields as filters. the filter should work as below for the respective KPI. all the KPI are in same sheet.
1. for Spend amount - Value will follow the selection in the filters, such as Fiscal year, Supplier name, Cat Lead, etc.
2. For other KPI like Supplier in ARIBA, reg. supplier, Qualified supplier etc - The value shall not focus on the Fiscal year, but for the other filters such as Cat lead.
please refer the screengrab for better understanding. what should be the condition used here. i tried set analysis
Hi,
For other KPI like Supplier ARIBA You can write something like this in the SetAnalysis:
Count({< [Fiscal Year]= >} Suppliers)
The "=" will take all values, no matter if a selection is made in the field.
Hi,
For other KPI like Supplier ARIBA You can write something like this in the SetAnalysis:
Count({< [Fiscal Year]= >} Suppliers)
The "=" will take all values, no matter if a selection is made in the field.
Thanks Steven. this worked