topic Re: Filtering via AND + OR in App Development

Filtering via AND + OR

bernhard_koehle — Mon, 30 Jan 2017 07:56:41 GMT

Hello,

I would like to ask you for the first time with a Qlik Sense question, which I can not solve currently.

Database is a table from which I would like to select 2 fields in the visualization. The input of all filters must be optional.

A simplified example of the data structure looks like this (all fields are of alphanumeric type):

Field1 Field2 Field3

Order No. Test Result

Each order can have n methods with one result.

My current app provides the following query options:

Display data where: (test1 with result1) AND (test2 with result2) AND ......... (test6 with result 6)

(So I can query 6 different tests with 6 diffrent results)

I solved this by a 6-times load of the identical table, whereby I renamed the fields in the loadskript.

The app works - even if I do not like this 6-times-load of identical data.

Now to my extension:

In addition to the 12 (optional) AND filters (6 methods with their 6 results), I also want to add the possibility of 12 (optional) OR filters.

eg.:

( (test1 with result1) AND (test2 with result2) AND ....... ) OR ( (test7 with result7) AND (test8 with result8) AND .... )

Solution:

An experiment in the visualization using IF works to link two OR fields.

If (WildMatch (GetFieldSelections (method1), '*' & result1 & '*') or WildMatch (GetFieldSelections (method2), '*' & result2 & '*'

However, using this type of solution for 12 -UND + 12 OR-linkages is only theoretical, since this construct would no longer be overlooked.

"Set Analysis" only works for aggregate functions. I don't beleave it's possible to use it.

Interesting Link:

I found this link: http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/

Very interesting. But as a beginner i have my problems to understand 🙂

And i don't wont to imagine how complex the solution would be if the AND and OR (at the same time !) is implemented. But of course it would be interesting if it would work.

Does anyone have a solution approach?

Thank you very much

Re: Filtering via AND + OR

sunny_talwar — Tue, 31 Jan 2017 10:37:41 GMT

Would you be able to share a sample of what you have and provide details of what you are looking to do with that sample?

Re: Filtering via AND + OR

bernhard_koehle — Tue, 31 Jan 2017 11:51:41 GMT

Hallo,

here is an example application with 12 fields which are linked by AND.

For the small amout of data the 12 filters are oversized

You can ask for e.g. orders with (Test1=FL and result1=100) and (Test2=NA and result2=10)

>>> order 200

In addition I am looking for the next 12 filters which are OR-linked to the first 12-filters.

I want to ask: orders with ( (Test1=FL and result1=100) and (Test2=NA and result2=10) ) OR ( (Test7=NA and result7=10) and (Test8=K and result8=20) and (Test9=CA) )

>>>> order 100 and 200

Any idea?

Regards

Re: Filtering via AND + OR

bernhard_koehle — Wed, 02 Aug 2017 05:03:53 GMT

Hello,

i found a solution for the problem.

Look into: Solution for filtering data by using AND + OR at the same time in Qlik Sense 3.2

There is a sample-app for better understanding.

Regards