Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Hiding excluded values

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

1 Solution

Accepted Solutions

Re: Hiding excluded values

May be try this

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

3 Replies
YoussefBelloum
Esteemed Contributor

Re: Hiding excluded values

Hi,

Maybe this on the listbox name (calculated dimension):

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


Hope it helps,

YB

Re: Hiding excluded values

May be try this

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

Re: Hiding excluded values

Check the attached sample also