topic Re: Decision Tree for Consolidated Filters in QlikView

Decision Tree for Consolidated Filters

Anonymous — Fri, 13 Jul 2018 15:20:13 GMT

Qlikverse,

My team wants to clean up our Filters on the side of our dashboard. Notice the current state is like the image below:

How can we roll up all of these filters to make it so that there is a list box where we first choose which filter we want to expand? From there, the list box would then display only the options for the given filter.

Here is a crude recreation of what we want that was mocked up in Paint for visualization purposes:

Regards and thanks in advance!

Re: Decision Tree for Consolidated Filters

YoussefBelloum — Fri, 13 Jul 2018 15:24:49 GMT

Hi,

one solution would be this:

1) load a separated table on the script like this:

FILTER_TABLE:

LOAD * inline [

FILTER

filter1

filter2

filter3

filterx

];

2) on the final filterbox (Image 2 left) try this expression:

=peek(match(FILTER,'','',''),yourfield1,yourfield2...)))

Re: Decision Tree for Consolidated Filters

neelamsaroha157 — Fri, 13 Jul 2018 15:41:52 GMT

This can also be achieved by variables and conditional show functionality.

create text box or button for for each value (in your bottom left image), create variable for each value with 0 or 1 value and in the action part alter the value of these variables.In the each list box, enable show/hide based on the variable value.

Re: Decision Tree for Consolidated Filters

neelamsaroha157 — Fri, 13 Jul 2018 15:50:31 GMT

Here is an example file.

Re: Decision Tree for Consolidated Filters

Anonymous — Fri, 13 Jul 2018 15:59:02 GMT

Excellent, thank you both. We are going back internally to try both of these options out. We'll keep you posted on the final design.