topic Dimension with Set Analysis expression in QlikView

Dimension with Set Analysis expression

Fri, 15 Jul 2011 14:31:38 GMT

Hi folks,

I have a funnel chart where the dimension is a 'Status' and the expression is a count by ID using set analysis, like this:

=Count( {$< Status= {"AAAAAA", "BBBBBB", "CCCCCC"} > } Id)

The chart is:

But... when I click in the blue colour on the chart, the chart is static...

All the dimensions around the sheet has changed... but the graph is the same.

I would like when I click on blue (represented by "AAAAAAA" status) the chart sould be:

How do I do that?

Thanks,

Rodrigo.

Re: Dimension with Set Analysis expression

johnw — Fri, 15 Jul 2011 22:08:10 GMT

Like this:

count({<Status*={'AAAAAA','BBBBBB','CCCCCC'}>} Id)

The *= is what's doing the work. When you just use =, you're saying "exactly these values, no matter what I select". When you use *=, you're saying "the intersection of what I've selected in Status and these values". I probably use *= more often than = because I'm trying to limit the selections, not override the selections.

Re: Dimension with Set Analysis expression

Mon, 18 Jul 2011 09:41:37 GMT

Perfect!!

Thank you!!!

Regards,

Rodrigo.