Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Filter value display

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

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Filter value display

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 Replies
stigchel
Honored Contributor

Re: Filter value display

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

Not applicable

Re: Filter value display

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

Not applicable

Re: Filter value display

Hi Piet,

It has been resolved.

Thanks so much. I am so grateful to you.

Thank You,