Combining Selections (Bookmarks?)

[#1]

Hello,

If I had a table with the following fields...

ID	Field1	Field2
1	a	c
2	b	c
3	a	d
4	b	d
5	a	c
6	b	c
7	a	d
8	b	d
9	a	c
10	b	c

and created listboxes for Field1 and Field2, how would I create a selection where the output was to extract all records where Field 1 = a OR Field 2 = c?

Thanks

John

[alexandros17]

If you select fields by a listbox you fill have your table filtered by that value, you can solve the problem loading data with a flag that sign the combinations of fields you need and using that flag in your expression

Hope it helps

[#3]

Thanks Alexandros but I'm not sure what you mean.

Could you attach a document that explains?

Thanks

John

[alexandros17]

Here it is an example, hope it helps

[#5]

Thanks for this Alexandros.

I was hoping that there was an easier way without re-loading the data.

The example I gave was a simplified version of what I was looking to do.

[vincent_ardiet]

Hi John,

Is your table a real table or a chart?

If it's a chart and if you have expressions in it, you can use set analysis to manage what you want.

You have to use an alternate state if you have QV11.

For example the list box for Field2 is in an alternate state named AS1.

With such an expression sum({$+<Field1=,Field2=AS1::Field2>} mymeasure)

Regards,

Vincent

Message was edited by: Vincent Ardiet

[#7]

Create a listbox for ID. Click on the titlebar of the listbox to select it.  Now, type this   =Field1='a' or Field2='c'    and hit enter. Make sure you start typing with the equal sign - that tells QlikView that you are entering a search expression. It will select all of the rows (by selecting ID) that meets your criteria.