Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter data based off selection in a table

Hi -

I have a table which I can filter using the filter pane. I have another table and I want to filter data in the second table based off the selection in the first table. How do I do that?

For eg Table 1:                                Table 2:

1/1/2016                                             1/5/2016

2/1/2016                                              5/5/2016   

3/1/2016                                                2/15/2016

4/4/2016

And I want to show all the rows that have data greater than the selection from table 1.

So if I select 2/1/2016 from table 1, table 2 data should filter to 5/5/2016 and 2/15/2016.

Thanks, Shilpi

4 Replies
girirajsinh
Creator III
Creator III

something like this

Date(Aggr(max({<DateOut={">=$(=Min(DateIn))"}>}DateOut), DateOut))

replace Dateout with Table1Date and DateIn with Table2Date fields

Not applicable
Author

Thanks Girirajsinh.

Do I put that in the column expression? or Filter Pane? When I use that expression, I do see the filtered data, but I need the data in my second table to filter per the selection.

Not applicable
Author

Thank you. I got it to work.

girirajsinh
Creator III
Creator III

I wrote it for Filter pane.

You may use similar for table you look for.