topic Re: Hiding excluded values in QlikView

Hiding excluded values

Thu, 28 Sep 2017 15:12:25 GMT

Hi, I have two listboxes, name and school. I selected a value in school so now there are only a few possible values in name, I want the greyed out values not to show up, but I do not want to use the hide excluded feature because when I click on a certain name, I still want the other names under that school to be present. Is this possible in anyway?

Thanks,

Natasha

Re: Hiding excluded values

YoussefBelloum — Thu, 28 Sep 2017 15:14:45 GMT

Hi,

Maybe this on the listbox name (calculated dimension):

=aggr(only({<name=P(name)>}name),name)

Hope it helps,

Re: Hiding excluded values

sunny_talwar — Thu, 28 Sep 2017 15:15:47 GMT

May be try this

Aggr(Only({1<school = p(school)>} name), name)

Re: Hiding excluded values

sunny_talwar — Thu, 28 Sep 2017 15:18:20 GMT

Check the attached sample also