topic Re: Ignore Field Selection in Set Analysis in QlikView

Ignore Field Selection in Set Analysis

max_potass — Thu, 22 Feb 2018 13:07:38 GMT

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

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 13:11:14 GMT

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?

Re: Ignore Field Selection in Set Analysis

max_potass — Thu, 22 Feb 2018 13:24:48 GMT

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...

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 13:39:41 GMT

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?

Re: Ignore Field Selection in Set Analysis

max_potass — Thu, 22 Feb 2018 13:54:33 GMT

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...

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 13:56:45 GMT

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)

Re: Ignore Field Selection in Set Analysis

isingh30 — Thu, 22 Feb 2018 14:06:07 GMT

Try 'only' function. Check below link.

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

Thanks.

Re: Ignore Field Selection in Set Analysis

max_potass — Thu, 22 Feb 2018 14:08:31 GMT

It is working. Thank you!

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

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 14:08:36 GMT

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

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 14:10:20 GMT

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.

Re: Ignore Field Selection in Set Analysis

isingh30 — Thu, 22 Feb 2018 14:18:37 GMT

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

Thank you!

Re: Ignore Field Selection in Set Analysis

max_potass — Thu, 22 Feb 2018 14:18:39 GMT

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

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 14:26:41 GMT

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

Re: Ignore Field Selection in Set Analysis

sunny_talwar — Thu, 22 Feb 2018 14:28:00 GMT

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.