Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 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
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
Hi Piet,
It has been resolved.
Thanks so much. I am so grateful to you.
Thank You,