Qlik expressions: Multiple selections within a filter

[Anonymous]

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

[sunny_talwar]

So, let me get this straight... you used the above expression in a KPI object and you selected US Consumer, US Pharma and US MD&D in your selection box and you didn't see 3000000000?

[Anonymous]

It worked! I made a spelling error, US Pharma is supposed to be US Pharm, thanks for your help!!! you deserve a monument in here

[sunny_talwar]

That was my bad.... glad it worked