Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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

sunny_talwar

May be try this:

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

or

=Aggr(Filter2, Filter2)