QlikView App Dev

[cliff_clayman]

I have a straight table chart with a dimension in which I would like to only return specific values.  I tried doing the following:

=If([Country] = 'USA', 'CANADA' [Country]

However, this still returns other countries.  How can I limit my results to just USA and CANADA?

[#2 · Accepted solution]

Hi,

Try this :

=if([Country]='USA' or [Country]='CANADA',[Country])

Also, Make sure Show All Values is unchecked.

Regards,

Anjali Gupta