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 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
Partner - Master
Partner - Master

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

View solution in original post

3 Replies
stigchel
Partner - Master
Partner - Master

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
Author

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
Author

Hi Piet,

It has been resolved.

Thanks so much. I am so grateful to you.

Thank You,