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

[sunny_talwar]

So, are you saying that all the above expressions are ignoring any selection you make (not just year)? Would you be able to share a screenshot of your data model? The reason I ask this is because I just want to make sure that your Field1 and Field2 are connected to everything else in your model.

Also, do you have any alternate states in the dashboard?

[max_potass]

Hi Sunny,

thank you for you quick response. Yes, every Selection I make is ignored. I tried 10 fields and the intersting thing is, that the numbers are not changing, but the order of the dimensions is changing.

They are connected. Note that Field 1 is "AE.Netto:Plan" and Field2 is "UKURS".

Sorry for the messy Data-Model...

[sunny_talwar]

So, if you select MMM.YY, nothing will change? What happens when you have no set analysis at all? Does it filter based on selection then?

Sum(Field*Field2)

Also, you did not mention about the alternate state?

[max_potass]

If there is no Set Analysis, everything is fine. Every other Expression is also fine.

Ther is an alternate state for the page, but every object inherits this. Also the other expression in the same object are fine as well and the filter is applied correctly.

Can I set an anlysis for Dimension? Just curious. Would be easier...

[sunny_talwar · Accepted solution]

Oh... you do have set analysis... I am guessing that selections are getting made in the alternate state also, right?

I think the issue is that you are using $ sign which mean that expression is in default state... try without the dollar sign....

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

[isingh30]

Try 'only' function. Check below link.

https://community.qlik.com/docs/DOC-8146

Thanks.

[max_potass]

It is working. Thank you!

In the Documentation it actually says, that this does not matter. Blank is interpreted as $. That was annoying.

[sunny_talwar]

Sorry, I might be missing something, but how is Only going to help max.potass?

[sunny_talwar]

This is the case when you don't have alternate state. But things change when you introduce alternate state into the picture. Because $ means Default State and blank means inherited state. Inherited state is the state that the expression have inherited from the object or sheet state.