Qlik Sense Multiple Selection

[aj_qliksense]

Hello,

I am working on an App that is sourced from a table in Oracle Database. Is there is way to allow users to to filter on multiple columns and return values based on these multiple selections.

City	Ind1	Ind2	Ind3
NY	Y	Y	Y
DC	Y	N	N
CA	N	N	Y
FL	N	Y	N

I would like to show one filter on the app that will have dropdown with 3 values Ind1,Ind2 and Ind3 . If the user selects ind1 and Ind3. The result set should return both NY and CA not NY alone.

so, the result set should be based on "Ind1=Y or ind3=Y" instead of  "Ind1=Y and ind3=Y".

Please advise

[ravi_goyal]

Any issue in adding multiple filters in app?

[ravi_goyal]

If your filter criteria is static then you can use a variable and add assign filter value to it and use that variable in if statements for data fields.

[aj_qliksense]

Ravi, Thanks for your response. How do I "assign filter value" to a variable? Could you please elaborate on using variable in if statements for data fields?