Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Combining searches

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

5 Replies
ecolomer
Master II
Master II

You can have a new list concatenate both

richard_chilvers
Specialist
Specialist
Author

Thanks Massimo.

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

richard_chilvers
Specialist
Specialist
Author

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
Creator
Creator

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.

islands.png

Hope this helps ...