We're currently using Qlik sense and are looking for a way to give our users access to complex filter options to give them the opportunity to look in to their own group of interest. Of course we can create these groups in the loadscripts, however this doesn't give our front-end users the flexibility we want. Since filtering is an important function in Qlik we're hoping that others had similar issues in the past.
The functionality we are looking for should include AND and OR filters within the same column, e.g. customers that bought a blue car and a green or a red car. Preferably we would also like to combine this with filtering on combining this with a column of another table, e.g. customers that bought a blue car and a green or a red car and have bought check-up A and B. In a perfect situation we could add AND NOT options and have the opportunity to specify results within a table, e.g. check-up A was done in the last year and the result was X. However, we would already be happy if we could make one of the first options available for our users in a user friendly way.
The search option as available in the QMC would perfectly suit our needs. Does anyone of you know if there is an extension available that works like this? Or has this ever been rebuild in Qlik? Qlik Cloud would also be an option for us if that would make it easier to solve this problem.
We already tried to build this in Qlik by making use of variable inputs. In this way we are already able to filter on customers that bought a blue car and a green or a red car. However, if we want to have the option AND/OR on both columns it's getting much more complicated, especially when taking UX and UI in to account. Therefore we are wondering how you would solve this problem.
You write "The search option as available in the QMC would perfectly suit our needs" - what search option are you referring to?
You could probably achieve the actual search results you need using set analysis. The P() function in set analysis can be used to select customers that bought cars of specific colors, and with set operators you could combine different conditions (AND / OR). Perhaps you could dynamically build approporiate set expressions using variables and selections. Build functional hard coded set expressions first, and then try to figure out how to make them dynamic. (It will not be easy...)
