topic Re: Combining searches in QlikView

Combining searches

richard_chilvers — Thu, 07 Aug 2014 15:43:43 GMT

I am not new to QlikView but I am struggling to achieve the search I want.

Suppose I have 2 list boxes A & B. I make a search using list box A. If I then search using list box B, I further restrict my search; in other words I see entries which pass search A and B.

I would like to combine my search using or instead - and see entries which have either codes from list A or from list B.

Advice please.

Thanks

Richard

Re: Combining searches

ecolomer — Thu, 07 Aug 2014 15:48:57 GMT

You can have a new list concatenate both

Re: Combining searches

maxgro — Thu, 07 Aug 2014 16:10:51 GMT

QlikView App: Create list boxes that work in an OR mode

Re: Combining searches

richard_chilvers — Thu, 07 Aug 2014 16:14:03 GMT

Thanks Massimo.

Steve always does good work, and its re-assuring that there is no obvious solution to this requirement.

Re: Combining searches

richard_chilvers — Mon, 11 Aug 2014 13:19:28 GMT

I have made some progress which may help others.

In my case, the selections which I want to combine are fairly static. So it is possible to set up a number of bookmarks which can then be combined within Set Analysis.

Its not an ideal solution because it limits the ability of the end user easily to vary selections. But the concept might be useful to others.

Regards

Re: Combining searches

mark_casselman — Wed, 01 Oct 2014 19:48:18 GMT

Hi,

Another option is to use 'data islands' and use set expressions:

An example:

Script:

Customers:

LOAD * Inline [

Customer, Field1, Field2, Value

1,B,X,10

2,B,Y,25

3,A,Y,15

4,A,Y,5

];

SelectTable1:

LOAD * Inline [

SelectField1

];

SelectTable2:

LOAD * Inline [

SelectField2

];

Expression:

sum({<Field1=SelectField1>+<Field2=SelectField2>}Value)

And add the fields SelectField1 and SelectField2 to you sheet.

Hope this helps ...