Combining searches

[richard_chilvers]

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

[ecolomer]

You can have a new list concatenate both

[maxgro]

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

[richard_chilvers]

Thanks Massimo.

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

[richard_chilvers]

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

[mark_casselman]

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

A

B

];

SelectTable2:

LOAD * Inline [

SelectField2

X

Y

];

Expression:

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

And add the fields SelectField1 and SelectField2 to you sheet.

Hope this helps ...