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 empty set. For example: sum({$<Year=>} Sales).
Related posts:
It is even simpler than that… Try sum({$} Sales).
The formula above is wrong… It should be sum({$<Year=>} Sales)
need help.
i want that my sum func. will sum all values
and ignore any selections except selection
in one field.
does it possible ?
thx
doron
I’m with doron, lets say i have the following simple dataset, Customer, Region, Product,Period,Sales
i am wanting to write an expression that will ignore the selection on Region (if any) ie lets call it National Sales. take into consideration the selection on Customer, Product, Period
sum({Region={“*”}} NationalSales)
thx to sean but i mean excatly on the contrary
from your example.
if i look on your example i want that the expration ignore any selection in any field but except selection on Region. if user select period and region the sales will calculate on all rows in any period but only row in the selected region.
hope i cleared my point.
thx
doron