Set Analysis

[diana_]

Hi All,

I would like my graph to react only to two filters, specifically to Product and FY, but not to other filters I have in app.

Sum({1<[Label name]={'Estimated Expense'},[Product]={'First'},[Table]={'Current'},[Side]={'2','3'},[FY]={'2018'} >} Value)

I was doing it with if, because I have two years and 2 Products only, but would like to formulate it to be flexible in case I have more Product and FY in future.

Please advise how I can make formula to react to 2 specific filters only, by the way, those two filters I have as a checkbox.

GetFieldSelections([Product]) and (GetFieldSelections([FY])

Thank you!

Best regards.

Diana

[tresesco]

Try like:

Sum({1<[Product]=$::[Product],[FY]=$::[FY] >} Value)

For better understanding read :https://community.qlik.com/t5/QlikView-Documents/Ignore-all-selections-except-few-fields-using-Set-A...