topic Re: Set Analysis w/ $ not changing with filter in QlikView

Set Analysis w/ $ not changing with filter

Anonymous — Tue, 15 Apr 2014 13:36:15 GMT

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?

Re: Set Analysis w/ $ not changing with filter

Colin-Albert — Tue, 15 Apr 2014 13:47:39 GMT

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.

Re: Set Analysis w/ $ not changing with filter

Tue, 15 Apr 2014 14:02:38 GMT

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

Re: Set Analysis w/ $ not changing with filter

Anonymous — Tue, 18 Sep 2018 10:22:13 GMT

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

Re: Set Analysis w/ $ not changing with filter

Anonymous — Wed, 19 Sep 2018 08:43:40 GMT

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