How to hide filter data's based on another filter selection

[Karthick30]

Hi , I have 2 fields. One is user ID's List and another one is their application access. I have added both the fields in filter pane(User Filter and Application Filter). Each user has different Application Access

Now Actual requirement is , if i select one user ID from 1st(user) filter then 2nd (Application)filter should show only whatever application that user has access and remaining application should hide. Same way for 2nd user, if I select 2nd user , then Application filter should show only2nd user Application only.

Any way to achieve this

[rwunderlich · Accepted solution]

For the application filter, use a calculated dimension expression like:

=Aggr(Only(Application), Application)

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

[Karthick30]

Thanks Much. It worked. Can you please let me know the logic behind this expression

[rwunderlich]

A normal filter box shows all values of a field.  What you asked was how to show only the "possible" values -- those values associated with the current selections.  This would be the behavior we would expect in a chart. 

So we use the chart aggregation function "Only()", which by default will consider only the possible values. Only() returns the field value. We could have instead used other aggregation functions like "Minstring" or "MaxString". We just needed some function to reference the data.

"Aggr" operates like a "for each" or "do over" .  So in English the expression means:

"Get the value of Application for each possible value of field Application". 

More on these functions can be found in the Qlik Help https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/functions-in-s...

-Rob

-Rob