Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Tell us which business and trade publications you read most regularly: RESPOND NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlik Expressions: Multiple Selections within Filters

Hello Qlik Community,

I am trying to write an expression where I can use the filters and data points change.

I can do if statements, such as if(country='US' and segment='Consumer', but I need help with a next step:

How would I write if there are two countries (Within the same field) Such as: If(country=US and Canada,Value

Please let me know if there is a solution to this. I appreciate it.

thank you


3 Replies


Hello, I am not sure if I understood it correctly but try:
If(country='US' or country='Canada', Value)

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Contributor III
Contributor III

Hi Wladimir - thanks for the reply. Unfortunately, that didn't work for me. It only picked up the first one. See the link above for photos of what I am looking for. thanks for the help