Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

shoaib986
New Contributor III

Qlik Sense - Set Analysis Ignore field does not work properly

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

Capture.PNG


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

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

1 Solution

Accepted Solutions

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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

15 Replies

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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.

shoaib986
New Contributor III

Re: Qlik Sense - Set Analysis Ignore field does not work properly

No . Everything is set to auto.

shoaib986
New Contributor III

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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
Valued Contributor III

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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

Highlighted
shoaib986
New Contributor III

Re: Qlik Sense - Set Analysis Ignore field does not work properly

i did try it, no luck !

shraddha_g
Honored Contributor III

Re: Qlik Sense - Set Analysis Ignore field does not work properly

If possible share sample app

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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

shoaib986
New Contributor III

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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

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.

Re: Qlik Sense - Set Analysis Ignore field does not work properly

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

Community Browser