Skip to main content

Announcements
Week 4: Discover ELT + ETL Strategies and Explore Predictive AI in Qlik Cloud - WATCH NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliker3
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

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
Author

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