Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter out rows on straight table?

How do I filter out rows of data on a straight table? I can't figure out where to the set analysis

Basically i have a field Ideas.Status and i only want those with values of Delivered or Rejected shown

11 Replies
Not applicable
Author

Sorry, my fault. I was using the wrong terminology.

I will try with a Straight table instead then, as a table box doesn't seem to be able to filter out rows

richard
Partner - Creator
Partner - Creator

1) Use a straight table (charttype)

2) Select a dimension field

3) Edit that dimension to look like: if(match(Ideas.Status, 'Delivered','Rejected')>=1, FieldName)

4) Enable the field "Supress when value is null"