Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

Show specific dimension values in a straight table chart

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?

1 Solution

Accepted Solutions
Not applicable

Hi,

Try this :

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

Also, Make sure Show All Values is unchecked.

Regards,

Anjali Gupta

View solution in original post

1 Reply
Not applicable

Hi,

Try this :

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

Also, Make sure Show All Values is unchecked.

Regards,

Anjali Gupta