Solved: Qlik Sense - Set Analysis Ignore field does not wo... - Qlik Community

Anonymous · ‎2017-12-22

Hey Guys,

Any idea about this strange behavior?

I am using Qlik Sense Nov 2017 Desktop Edition.

I am using a simple set analysis expression which is sum({$<Year=>} Value*Sign) to ignore selection in year field in the chart SEASONALITY. But it is not working properly. Before selection

After selecting 2017 in Year Field, the legends are gone, the colors of the bars for 2016 and 2018 are gone, and on mouse over the bar, the year is being shown as null. Sum Amounts in Value labels are correct.

I have used the same data and same expression in Qlikview, it works as expected that nothing at all happens in the chart after making selection in Year field.

Thanks

SAK

rwunderlich · ‎2018-01-06

That looks like an an incorrect behavior to me. I can reproduce on Nov2017 SR1 and Sept2017. Attached is a sample app. It's as if it behaves with a color by dimension value that doesn't pick up the set expression.

I suggest checking in with QT support on this.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

sunny_talwar · ‎2017-12-22

Are you using a separate expression for color, popup? If you are, then make sure to add the same set analysis to ignore selection in year. Because although you main expression ignores selection in year, you other expression seems to be not.

Anonymous · ‎2017-12-24

No . Everything is set to auto.

Anonymous · ‎2017-12-24

The thing is i just copied the same load script, chart dimensions and chart expression from Sense to View, it is working perfectly fine as expected from the expression.

pradosh_thakur · ‎2017-12-24

is include null values unchecked in the dimensions in qliksense ? if not then uncheck and try.

Learning never stops.

Anonymous · ‎2017-12-24

i did try it, no luck !

shraddha_g · ‎2017-12-24

If possible share sample app

sunny_talwar · ‎2017-12-25

Would you be able to share a copy of your app?

Anonymous · ‎2018-01-06

I don't have app with sample data. It's just crazy situation. It's just terrible to troubleshoot it.