Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello, I am not sure if I understood it correctly but try:
If(country='US' or country='Canada', Value)
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