There needs to be a way to say “apply current selections, but ignore any selections in field A”. I submitted this as a feature request, but I hope someone from QlikTech sees this post. My proposed syntax is sum({$<!Year><!Month><!Week><!Date>} Sales). Otherwise, you need to use a positive assertion that lists each and every value, or calculates it on the fly. See my previous post and the use of concat() within a variable definition.

I guess I’ll eat those words. It seems, though I only have the beta and it may change, that to ignore selections in a given field, you can override the field value with an impossible value. For example: sum({$<Year=-1>} Sales). So far this behavior is consistent and correct.

Related posts:

1. QlikView 8.5 Introduces “Set Analysis”
2. Seeing Dollar Signs in QlikView 8.5
3. Feedback For Expression Variables
4. What’s “possible” in QlikView 9…
5. Using Variables In QlikView Layout