topic Re: filter records using OR-statement in QlikView

filter records using OR-statement

Wed, 23 Oct 2013 07:11:18 GMT

Hi,

I have a 'problem' related to filtering records. I have a dataset like:

business	act. 1	act. 2	act. 3	act. 4	act. 5	act. 6	act. 7
b1	x	x	x	x			x
b2		x			x
b3	x		x	x
b4		x		x		x
b5			x				x
..

now I have created a combobox (using the LOAD * INLINE function ) with all activities. Selecting the activities in the combobox should result in a filter on the dataset.

example results:

combobox selection	result
act. 1	b1, b3
act. 1, act. 2	b1, b2, b3, b4
act. 2, act. 6	b1, b2, b4
act. 5, act. 6	b2, b4

I need to create a sort of OR-statement....but I have no idea where to start. Most filters are based on the AND-statement (selecting act. 1 and act. 2 would result only in b1).

Anyone an idea?

Thanks in advance.

Per

Re: filter records using OR-statement

jonathandienst — Wed, 23 Oct 2013 07:20:26 GMT

If you select, for example, act.1 and act.2 in one list box, then the filter will be an OR filter be default; so values matching act.1 or act.2 will be returned.

Create a filterbox from the source data rather than in INLINE so that it is linked to the data.

HTH

Jonathan

Re: filter records using OR-statement

Wed, 23 Oct 2013 07:33:40 GMT

You just need to convert your first given table into a Cross Table. and that will do the trick.

Hope it helps

Re: filter records using OR-statement

Wed, 23 Oct 2013 07:34:10 GMT

Hi Jonathan,

thanks for the fast reply. It works perfectly. My dad used to say Keep It Simple St...and this time I again allmost created a complex solution for such a simple problem.

regards

Per