How do I restrict the entries in a list box ?

[#1]

Hi All,

I have a list box which lists employee names (Employee_Name). I would like to only list those names in the list box depending on the selection in another field (Department_Name). Currently it lists all the names for all departments.

Thanks

MV

[Anonymous]

you can use "hide excluded" in the defintion of the listbox.

you will see gray rows instead

[ashfaq_haseeb]

Hi,

Right Qlik on Employee list box --> go to properties --> General tab --> Select hide excluded.

Regards

ASHFAQ

[tresesco · Accepted solution]

List box expression: =Aggr(Employee_Name,Employee_Name)

[MK_QSL]

Instead of selecting Employee_Name Field in List Box, use below expression in List Box ... This will solve your purpose..

Aggr(Employee_Name,Employee_Name)

[rustyfishbones]

Create a List Box with Expression

And then add the following expression like tresesco says above

[aveeeeeee7en]

Hi

Use Expression: Aggr(ListBoxName,ListBoxName) or Aggr(Only(Name),Name)  in List Box whose values you want to hide.

See the Snapshots:

Also, see the Attached QVW.

Regards

Aviral Nag

[#8]

Hi,

I did as you suggested but all it did was create a list box with two columns of identical names.Maybe I didn't explain myself clearly enough.

I have a container object with two pivot tables - one for Department A, the other for Department B. If I select Department B pivot table, I only want those employee names associated with Department B to be listed in the Employee Name listbox.

The same principle applies to the Department A pivot table.