topic Re: Set analysis is overwriting selection filters in QlikView

Set analysis is overwriting selection filters

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I am running into an issue where my Set Analysis Filter is overwriting the Current Selections on the dashboard.

I have a table that only counts orders where we received payment on. However, if I want to filter on high paid orders, it doesn't work correctly.

If I have a filter that says only show orders with a payments of > 500, it isn't getting applied to the below set analysis.

Set analysis:

=count({$<[Order Total Payments] = {"$(= '> 0')"}>}Distinct [Order Number])

The set analysis counts all orders over $0, and ignores my $500 filter. Is this expected behavior? Any ideas on a work around? I always expected set analysis to work with the current selections if the $ was applied.

Thanks

Re: Set analysis is overwriting selection filters

sunny_talwar — Tue, 27 Sep 2016 16:42:59 GMT

May be try this expession:

=Count({$<[Order Total Payments] *= {"$(= '> 0')"}>}Distinct [Order Number])

Re: Set analysis is overwriting selection filters

Tue, 27 Sep 2016 18:42:14 GMT

Yep, that did the trick. Thank you! Could you explain what the * before the equal sign does? I haven't seen that syntax before.

Re: Set analysis is overwriting selection filters

sunny_talwar — Wed, 28 Sep 2016 00:53:17 GMT

* is used for intersection. In this particular case, it is looking for intersection between your current selection and and your specified modifier (>=0)

Read about this here:

Implicit Set Operators

Re: Set analysis is overwriting selection filters

Mon, 03 Oct 2016 12:44:48 GMT

That blog post was very informative. Thanks!