Auto select filter in Qlik Sense

[vibhu22oct]

Hi ,

Can it be possible to auto select filter value based on other filter selection in Qlik Sense?

Example , I have below sample data . I created two filters - Product and Category as shown below . If I select value “P1” then the corresponding value “C1” value should be automatically selected ( i.e. without manual selection by user)

Sample Data:

Filters :

Product Filter

Category Filter

[theoat]

If product and category are related in the data model, then a selection on P1 will be as restrictive as a selection on C1.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[rwunderlich]

Just to clarify one point. If Product and Category are associated, then Category is implicitly selected when you make a selection in Product.  You likely already know that, but I wanted to clarify as there sometimes is a misunderstanding as to how the associative model and implicit selections work.

If you need to make an actual selection in Category, for visual or some other reason, then you can do so by creating your listbox with an  Aggr() expression like:

=Aggr(Only({1} Product), Product, Category)

See https://qlikviewcookbook.com/2016/01/scoping-selections-with-aggr/ for more examples.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com