How to organize a large number of filters in an app.

[bartsimpson77]

Greetings all,

I have a QlikView app that has a large number of filters. Right now it is set up so that there is a separate tab within the app entirely filled with list box filters. Then the content is displayed on other tabs.

I'd like to set something up where there is a thin filter section on the left of the app with "category" buttons. So someone could click the button for "filter category 1" and it would display a container or something showing all of the list boxes for data elements in category 1 that the user could interact with and then dismiss.

Wondering if anyone could give me some pointers on how to accomplish this.

Here's an MS Paint masterpiece illustrating what I'm talking about:

[sudeepkm · Accepted solution]

This can be achieved by using a show hide mode for filter fields.

You can create a field using inline load like "_Filters"

FitlerArea:

Load * inline [

_Filters

Filter Category1

Filter Category2

Filter Category3

Filter Category4

Filter Category5

];

Then use this field in a list box in your Sheet and then

You can control the visibility of respective filter fields per category by using each filter fields properties > layout > conditional display.

For example assume that "Filter Category1" has 5 list boxes then on each list boxes > properties > layout > condition would be _Filter = 'Filter Category1'

So that when end users select "Filter Category1" from the Filter area list box then it shows the Filter fields related to "Filter Category1".