topic Re: Show specific dimension values in a straight table chart in QlikView https://community.qlik.com/t5/QlikView/Show-specific-dimension-values-in-a-straight-table-chart/m-p/1173852#M463571 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this :</P><P></P><P>=if([Country]='USA' or [Country]='CANADA',[Country])</P><P></P><P>Also, Make sure Show All Values is unchecked.</P><P></P><P>Regards,</P><P>Anjali Gupta</P></BODY></HTML> Wed, 22 Jun 2016 18:03:41 GMT 2016-06-22T18:03:41Z Show specific dimension values in a straight table chart https://community.qlik.com/t5/QlikView/Show-specific-dimension-values-in-a-straight-table-chart/m-p/1173851#M463570 <HTML><HEAD></HEAD><BODY><P>I have a straight table chart with a dimension in which I would like to only return specific values.&nbsp; I tried doing the following:</P><P></P><P>=If([Country] = 'USA', 'CANADA' [Country]</P><P></P><P>However, this still returns other countries.&nbsp; How can I limit my results to just USA and CANADA?</P></BODY></HTML> Wed, 22 Jun 2016 16:41:21 GMT https://community.qlik.com/t5/QlikView/Show-specific-dimension-values-in-a-straight-table-chart/m-p/1173851#M463570 cliff_clayman 2016-06-22T16:41:21Z Re: Show specific dimension values in a straight table chart https://community.qlik.com/t5/QlikView/Show-specific-dimension-values-in-a-straight-table-chart/m-p/1173852#M463571 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this :</P><P></P><P>=if([Country]='USA' or [Country]='CANADA',[Country])</P><P></P><P>Also, Make sure Show All Values is unchecked.</P><P></P><P>Regards,</P><P>Anjali Gupta</P></BODY></HTML> Wed, 22 Jun 2016 18:03:41 GMT https://community.qlik.com/t5/QlikView/Show-specific-dimension-values-in-a-straight-table-chart/m-p/1173852#M463571 2016-06-22T18:03:41Z