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: 
Anonymous
Not applicable

Set Analysis w/ $ not changing with filter

The below expressions are being used in a line/bar chart and the count values are not changing when a filter is applied to the View_Incidents_Within_24h field.  If I select the all the values in View_Incidents_Within_24h greater than 0, my bar chart does not change in anyway.

No Call After View: Count(DISTINCT {$<View_Incidents_Within_24h={0}>} View_Viewed_By)

Call After View:  Count(DISTINCT {$<View_Incidents_Within_24h={">0"}>} View_Viewed_By)

Shouldn't No Call After View disappear from the bar chart because we are using "$" and the current filter is excluding 0?

4 Replies
Colin-Albert

Because you have set a specific value for View_Incidents_Within_24h in your set expression, this will override the value in the current selection set ($). Hence you will see data for No Call After View and Call After View even when you explicitly select zero.

Not applicable
Author

Hi Nick,

the $-Sign within SET Analysis means that all User-Selections will be respected in this expression.

BUT in your case with one exception:

View_Incidents_Within_24h={0},

as you hard-coded it in your expression.

Analog in second expression.

HtH

Roland

Anonymous
Not applicable
Author

Can you tell if there is a way to overcome this scenario?

Anonymous
Not applicable
Author

If you want app level selections and expression level selections to work together (for same field), here is the solution

Count(DISTINCT {$<View_Incidents_Within_24h*={0}>} View_Viewed_By)


* will act as intersection.

Scenario 1: App selection: View_Incidents_Within_24h = 0. 0 intersection with 0 will be 0. So data related to 0 is shown.

Scenario 2: App selection: View_Incidents_Within_24h = 1. 0 intersection with 1 will be Nothing. So no data is shown.

Scenario 3: App selection: none for View_Incidents_Within_24h. None intersection with 0 will be 0. So data related to 0 is shown.


Hope this helps.

Src: Set analysis filtering see answer by jontydkpi