Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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

maxgro
MVP
MVP

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