Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikNoviceDeveloper
Contributor
Contributor

Filter condition - Need help here

Capture.PNGHi All,

Above is my dataset. now when i apply filter on Col6(list Box) let say value "33" the table shows 2 records . Cuz the col6 has 2 records in table. But instead i need 3 rows . i.e 2 rows matching value 33 and also the last  records if col4 is not null.

 

 

 

 

 

Labels (1)
1 Reply
qliksus
Specialist II
Specialist II

Maybe something like

 

Sum(Col1) + Sum({<Col6={"=getselectedcount(Col6)>1"} ,Col4={"=max(Col4)"},Col6=>} Col1)