Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
danaleota1
Creator
Creator

A filter automatically applied once another filter is chosen

Hello,

I would like to autofilter a dimension based on the filter of another dimension.  I have a hierarchy: "Supervisor" < "Manager".  

I would like the dimension "Manager" be autofiltered as soon as the field "Supervisor" is chosen.  I then have a measure in a bar chart that will respect that "Manager" filter.  

For the dimension I've tried

=AGGR(ONLY({<GetFieldSelections(Supervisor)>} Manager), Manager)  

or

=AGGR(ONLY({<Supervisor = {'=GetFieldSelections(Supervisor)'}>} Manager), Manager)

or 

=AGGR(ONLY({<Supervisor = {'GetFieldSelections(Supervisor)'}>} Manager), Manager)

 

These didn't work.  Any help would be great thanks!

 

Dana 

0 Replies