Ristrict values in a list box by selection

[Anonymous]

Hi All,

I created two List boxes Function and Department. If I click on any value in Function i want to show that particular Department values in Department list box.

Thanks,

Krishna.

[sunny_talwar]

Not sure what you mean? When you select Audit & Assurance, what do you have to see in Department?

[tresesco]

May be this: Listbox ->properties->General tab-> Check 'Hide Excluded'

[vikasmahajan]

tick on hide exclude option in list box as tesesco suggests.

Vikas

[sujeetsingh]

I agree with hide exclude option. Well please come up in more words.

[ahmar811]

Hi

Krishna

try below link

hierarchy problem

and

https://community.qlik.com/thread/52685‌

hope this help you

Thanks & Regards

Ahmar Ansari

[Anonymous]

Hi Sunny,

When you select Audit & Assurance, I want to see Statutory Audit only.

Thanks,

Krishna.

[HirisH_V7]

Hi,

Check this way,

In Department ListBox Expression,

=aggr(Department,Department)

else ,

Check hide excluded.

Hope this Helps,

PFA,

Hirish

[sunny_talwar]

You can either use an aggr() function to hide it just when you select a function (on other field selections the department list will still be available:

=Aggr(Only({1<Function = $::Function>}Department), Department)

or it hides based on selection in any field

=Aggr(Only(Department), Department)

or as tresesco‌ mentioned, you can use 'Hide Excluded option.

I have added all three options in your sample, check them out.

Best,

Sunny

[awhitfield]

Hi krishna4bo,

just ticked hide exclude on the department list box and you will only see departments applicable for the selected function, like the one on the left below:

HTH

Andy