Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Ken

3 Replies
Wlad_Masi
Employee
Employee

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.
Anonymous
Not applicable
Author

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