topic Re: Combining Selections (Bookmarks?) in QlikView

Combining Selections (Bookmarks?)

Thu, 14 Feb 2013 15:33:08 GMT

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

Re: Combining Selections (Bookmarks?)

alexandros17 — Thu, 14 Feb 2013 15:53:52 GMT

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

Re: Combining Selections (Bookmarks?)

Thu, 14 Feb 2013 15:59:19 GMT

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

Could you attach a document that explains?

Thanks

John

Re: Combining Selections (Bookmarks?)

alexandros17 — Thu, 14 Feb 2013 16:19:05 GMT

Here it is an example, hope it helps

Re: Combining Selections (Bookmarks?)

Fri, 15 Feb 2013 09:43:34 GMT

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.

Re: Combining Selections (Bookmarks?)

vincent_ardiet — Fri, 15 Feb 2013 10:10:08 GMT

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

Re: Combining Selections (Bookmarks?)

Tue, 26 Feb 2013 21:00:06 GMT

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.