Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
priyash92
New Contributor III

Hide Greyed out Values in Filter Boxes

Hello Guys,

I have 4 filter boxes in one sheet. What I want is to hide the greyed out values totally based on selection in previous filter box

For example

Current Scenario:

The Filter Value selected by User is depicted in BOLD

Filter1   Filter 2

A          1( Visible with white background)

B          2 (Visible with white background)

C          3 (Greyed out since option not available for Filter1 selection A)

D          4 (Greyed out since option not available for Filter1 selection A)

Output Wanted:

Filter1   Filter 2

A          1( Visible with white background)

B          2 (Visible with white background)

C         

D         

I read through the forum however did not understand how AGGR function is exactly used in this scenario.

Could someone please help me with the solution.

Thank.

Best,

Priyash

1 Solution

Accepted Solutions
priyash92
New Contributor III

Re: Hide Greyed out Values in Filter Boxes

Stupid Mistake on My End

The Answer to this is simple: In the 2nd filter box: the Field entry should be Aggr(Filter2,Filter2) instead of simply Filter2

2 Replies
priyash92
New Contributor III

Re: Hide Greyed out Values in Filter Boxes

Stupid Mistake on My End

The Answer to this is simple: In the 2nd filter box: the Field entry should be Aggr(Filter2,Filter2) instead of simply Filter2

Re: Hide Greyed out Values in Filter Boxes

May be try this:

=Aggr(Only({1<Filter1 $::Filter1>}Filter2), Filter2)

or

=Aggr(Filter2, Filter2)