Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
cliff_clayman
Contributor 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

Re: Show specific dimension values in a straight table chart

Hi,

Try this :

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

Also, Make sure Show All Values is unchecked.

Regards,

Anjali Gupta

1 Reply
Not applicable

Re: Show specific dimension values in a straight table chart

Hi,

Try this :

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

Also, Make sure Show All Values is unchecked.

Regards,

Anjali Gupta