Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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