Set Analysis

diana_ — Sat, 16 Nov 2024 05:19:02 GMT

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

Re: Set Analysis

tresB — Thu, 11 Jul 2019 09:47:56 GMT

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-Analysis/tac-p/1524886

topic Re: Set Analysis in App Development

Set Analysis

Re: Set Analysis