topic Multiple bookmarks in QlikView

Multiple bookmarks

Fri, 08 Jul 2011 15:10:08 GMT

Hi all - Just a quick question about bookmarks. I've been using the GoogleChart API to return a simple '3 Group Venn Diagram'. It does this by saving 3 selections in different bookmarks: BM1, BM2 and BM3. The venn is excellent at visualizing the overlap between the groups eg. Booked in 2011, Booked in 2010 and Booked in 2009.However, when I wanted to grab a list of the people who appear in all 3 groups I can't seem to find a way to do it. In essence I want to select the customers who appear in all three bookmarks and cana't seem to find a way to do that. Please help many thanks Mark.

Multiple bookmarks

swuehl — Sat, 09 Jul 2011 11:20:26 GMT

Hi Mark,

If I understand you correctly, you want an intersection of the three bookmark selection with regard to field customer,

maybe using a set expression like

count(distinct {< Customer = p({BM1}) * p({BM2}) * p({BM3}) >} Customer)

For example, if you use this expression as expression in table with dimension customer, it should list only the customers which are within all three groups.

If you want to select these customers, I am currently thinking of kind of trigger action (e.g. with a button), but haven't made up my mind how to do that.

Is this of any help for you?

Have a nice weekend,

Stefan

Multiple bookmarks

Mon, 11 Jul 2011 07:21:27 GMT

Many thanks for the answer Stefan - however, it's actually selecting the people, not doing a count that I'm trying to acheive.

Multiple bookmarks

kaushiknsolanki — Mon, 11 Jul 2011 07:28:14 GMT

Hi,

Do you just need a count of those customers, not the name...?

If yes then try the same expression in a textbox.

Regards,

Kaushik Solanki

Multiple bookmarks

Mon, 11 Jul 2011 07:37:48 GMT

Hi Kaushik - no, I need to select these customers as a group, maybe for a mailing or to do further analysis.

Multiple bookmarks

swuehl — Mon, 11 Jul 2011 22:17:59 GMT

Hi Mark,

maybe you could use the given expression as expression e.g. in a listbox (field customer) and select then all values with an result (using a serch filter). Is this feasible?

Regards,

Stefan

P.S. I think expression in a list box needs QV version >= 10

Multiple bookmarks

magavi_framsteg — Tue, 12 Jul 2011 08:07:28 GMT

Hi mark.phelps.

I think you might end up with some problems.

See my post http://community.qlik.com/thread/31594.

If all field criterias in your BM:s are not applicable (not able to be selected for some reason) your BM will still select all other fields.

The BM should be illegal if all fields defined in it cannot be selected, but I have not yet found a way of checking that.

Multiple bookmarks

swuehl — Tue, 12 Jul 2011 09:49:12 GMT

Hi Mark,

I think my suggestion with an expression to the listbox might not work.

But I got this working:

- Straight table chart

- customer as dimension

- expression given above as expression (if you don't like the plain count you could convert it to e.g. "Match" with a simple additional if case, like if (count (..)>0, 'Match')

This should result in a table, with customer limited to the set expression selection.

I enabled "searchable" for the expression column in properties->presentation

If I click on the search icon of the expression column and type in *1* (or *Match*), all the customers within the desired selection are selected.

Hope this helps,

Stefan