Ignore Field Selection in Set Analysis

[max_potass]

Hello everyone,

I currently am loosing my mind over a stupid problem... I simply want to ignore the selection of a field via set analysis... I tried following (including directly set a value):

Sum({$<year={2018}>}Field*Field2)

Sum({$<year={}>}Field*Field2)

Sum({$<year={$(=start_cur_year)}>}Field*Field2)

Sum({$<year = >}Field*Field2)

And every freaking time it ignores every Selection I have made (Yes, "year" itself and every other field!!!). I even copied the suggestion for this problem out of the official Qlikview site and just replaced the Field name and it still did not work. I looked at about 20 threads and no one has this problem...

I have no Clue whats going on and I am that close to exploding and ruining everyones day over this f***ing problem. Maybe I am just stupid, but I tried to fix it for hours and I am not succeeding.

Does anyone know what is happening or why this is not working? I would be thrilled if someone could help me...

Best Regards and Thanks

Max

[isingh30]

I thought we can select specific things in the field by this function. Correct me if i am wrong.

Thank you!

[max_potass]

Interesting that this is not mentioned in the documentation. Thanks.

[sunny_talwar]

Documentation is not perfect. We all have seen some errors in the documentation. Not sure what else to tell you

[sunny_talwar]

Well Max also have an aggregation function (Sum), it won't be right to add Only on top of Sum and regardless it is not going to do any good to him... at least from what I see.