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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
qliker3
Creator
Creator

Filter data in filter pane and show it in table

Hi,

 

I have the following table:

rid eid
null 1
2 2
3 null
4 4
null 5

I want the table to only show rows with values "1" and "5". In the filter pane, if "2" is chosen, the table should not display anything.

How can I implement this?

 

Thanks  

 

2 Replies
Gabbar
Specialist
Specialist

i Suppose you are talking about 1 and 5 in eid,
Try this :
In you table select eid as Dimension 
and as  measure write Only({<eid={'1','5'}>}rid)

qliker3
Creator
Creator
Author

no, i want to filter this values out automaticaly, without expilicitly writing '1','5'? Is it possible?