topic Re: Ristrict values in a list box by selection in QlikView

Ristrict values in a list box by selection

Anonymous — Wed, 13 Apr 2016 04:21:27 GMT

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.

Re: Ristrict values in a list box by selection

sunny_talwar — Wed, 13 Apr 2016 04:25:15 GMT

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

Re: Ristrict values in a list box by selection

tresB — Wed, 13 Apr 2016 04:37:31 GMT

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

Re: Ristrict values in a list box by selection

vikasmahajan — Wed, 13 Apr 2016 04:38:44 GMT

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

Vikas

Re: Ristrict values in a list box by selection

sujeetsingh — Wed, 13 Apr 2016 04:47:16 GMT

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

Re: Ristrict values in a list box by selection

ahmar811 — Wed, 13 Apr 2016 04:49:57 GMT

Krishna

try below link

hierarchy problem

and

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

hope this help you

Thanks & Regards

Ahmar Ansari

Re: Ristrict values in a list box by selection

Anonymous — Wed, 13 Apr 2016 04:52:44 GMT

Hi Sunny,

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

Thanks,

Krishna.

Re: Ristrict values in a list box by selection

HirisH_V7 — Wed, 13 Apr 2016 04:54:30 GMT

Hi,

Check this way,

In Department ListBox Expression,

=aggr(Department,Department)

else ,

Check hide excluded.

Hope this Helps,

PFA,

Hirish

Re: Ristrict values in a list box by selection

sunny_talwar — Wed, 13 Apr 2016 09:40:21 GMT

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

Re: Ristrict values in a list box by selection

awhitfield — Wed, 13 Apr 2016 11:16:46 GMT

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