Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis is overwriting selection filters

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this expession:

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

View solution in original post

4 Replies
sunny_talwar

May be try this expession:

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

View solution in original post

Not applicable
Author

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

sunny_talwar

* 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

Not applicable
Author

That blog post was very informative. Thanks!