Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ristrict values in a list box by selection

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.

9 Replies
sunny_talwar

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

tresesco
MVP
MVP

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

vikasmahajan

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
sujeetsingh
Master III
Master III

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

ahmar811
Creator III
Creator III

Hi

Krishna

try below link

hierarchy problem

and

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

hope this help you

Thanks & Regards

Ahmar Ansari

Anonymous
Not applicable
Author

Hi Sunny,

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

Thanks,

Krishna.

HirisH_V7
Master
Master

Hi,

Check this way,

In Department ListBox Expression,

=aggr(Department,Department)

Hide Excluded Aggr.PNG

else ,

Check hide excluded.

Hope this Helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
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.

Capture.PNG

Best,

Sunny

awhitfield
Partner - Champion
Partner - Champion

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