QlikView filters are essential for data discovery. A nice visualization without filters can hinder your end-users from uncovering valuable insight or important trends.

One of the conundrums you face as a developer is to provide all the filters your users need, especially if there are many important filters your users need.

Enter dynamic filters. A simple trick that may allow you to show virtually all the filters without cluttering your dashboard.

Add a list box with expression to show $Field system field. We will use AGGR() function and Set Analysis to exclude key fields(In our example, fields with name starting with ‘%’ or fields containing word ‘ID’)

dynamic filters1

Now, let’s add another list box with a dollar-sign expansion to show field values.

dynamic filters2
Now, select a field and you will see values for the given field to select from. Once you select values, you can select another field and select values and repeat the process.

Related Posts Plugin for WordPress, Blogger...