Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dimension with Set Analysis expression

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:

Untitled.png

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:

Untitled1.png

How do I do that?

Thanks,

Rodrigo.

1 Solution

Accepted Solutions
MVP
MVP

Re: Dimension with Set Analysis expression

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.

2 Replies
MVP
MVP

Re: Dimension with Set Analysis expression

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.

Not applicable

Re: Dimension with Set Analysis expression

Perfect!!

Thank you!!!

Regards,

Rodrigo.

Community Browser