topic Set Analysis - Comparing selections on a chart using bookmarks in QlikView

Set Analysis - Comparing selections on a chart using bookmarks

Tue, 20 Jul 2010 00:39:02 GMT

Hello,

In my attached QVW document, I have SET 1 which is just SAFEWAY in California. SET 2 is another set of retailers (Costco and walmart). I want to be able to display both SET1 and SET2 plots onto my graph. It was suggestsed that I can set both bookmarks in different dimensions. I'm strugging with this for a few days and can't get any further.

Could you help point me in the right direction.

thanks,

Set Analysis - Comparing selections on a chart using bookmarks

Tue, 20 Jul 2010 14:08:19 GMT

Hey Mike,

The idea is to use two set analysis in the expressions.

Expression 1: sum({$ * Bookmark01} Sales)
Expression 2: sum({$ * Bookmark02} Sales)

This set anaysis will return sales for the intersection between the current selection and the bookmark "Bookmark01".

Set Analysis - Comparing selections on a chart using bookmarks

Tue, 20 Jul 2010 16:50:14 GMT

Hey Kristen,

I did exactly what you described and added two new expressions into my Chart Properties (Map).

=sum({$*Set1} Quantity)

=sum({$*Set2} Quantity)

Still I am unable to see plots on my Map which shows both retailers from Set1 and Set2 simultaneous.

Any additional thoughts/suggestions you might be able to share?

Thanks,