Filter value display

[#1]

Hi,

I have two filters on an excel sheet. The filters are 'employee group' and 'employee name'. by default all the groups and all employee names are shown in the filters. When a employee group is selected, the related employee names are shown in white in the employee name filter, and, remaining are highlighted in black/grey.

Is there any way out where when I select a group, the name filter should show only the records related to the selected group??

Please help.

Thanks,

Rahul Krishan Goyal

[stigchel · Accepted solution]

Not sure about Sense, but in qlikview you can use an expression in a listbox instead of a field.

If you can do this in Sense then use an expression like

=Aggr(Only([employee name]),[employee name])

And the listbox will only display the possible 'white' values

[#3]

Hi Piet,

Thanks so much for your response.

Though, I am able to apply the function in Qlik sense also. But, in the list boc / filter drop down, no value is shown/showing blank list box.

Please help.

Rahul

[#4]

Hi Piet,

It has been resolved.

Thanks so much. I am so grateful to you.

Thank You,