Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
johnw
Champion III
Champion III

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.

View solution in original post

2 Replies
johnw
Champion III
Champion III

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
Author

Perfect!!

Thank you!!!

Regards,

Rodrigo.