Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a KPI which is looking at the SUM of the budget for sales.
I have a three filter panes
1. Filter on the Country/Division/Budget Holder/Office
2. Filter on Year
3. Filter on the state of the Opportunity (new/won/lost)
The problem I have is that I only want this KPI to be impacted by filters 1/2, because there is no relationship in the data model between the State of the Opportunity, and the amount budgeted.
I have tried using this structure but it only seems to work if I want to limit it to Filter 2, not Filter 1 or 2.
sum({1<FieldToKeep=P(FieldToKeep)>}Fieldname)
eg. sum({1<spending_year=P(spending_year)>}amount)
Ideally, i'd like to be able to continue to filter but ignore the filter on new/won/lost because if it is included it sums to 0
Referring to master dimensions in expression is not yet possible in Qlik Sense As of Jan 2021..
You can move the IF condition to script and create new field and use new field in set expression and filter.
Also whenever possible avoid using calculated dimension at front-end.
You can Ignore field selections by adding <fieldName> = .. in Set Expression.. Try below syntax :
sum( {< fieldToIgnore = > } amount)
Referring to master dimensions in expression is not yet possible in Qlik Sense As of Jan 2021..
You can move the IF condition to script and create new field and use new field in set expression and filter.
Also whenever possible avoid using calculated dimension at front-end.