Change Filter based on Selection

[garyvary123]

Hi guys, I'm trying to make a filter that changes based on the filters available for a certain day.

I currently have a slider date variable input and I want to make my dropdown on my filter change with the available options on that day. 

For example: 

Only oranges and apples are available on 12/21/2021

Only grapes and watermelons are available on 12/22/2021

These foods fall under the measure 'Fruits', when I put Fruits as the filter and select date 12/21/2021, I see all 4 options. I would like to only see oranges and apples on the dropdown.

Would appreciate any help! Thank you!

[anat]

can u try "Hide Excluded" in qlikview listobject

[garyvary123]

Thanks for your suggestion but this isn't what I want. This gets rid of the selections after applying the filter and does not update what the filter shows based on date.