Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

15 Replies
sunny_talwar

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
Not applicable
Author

No . Everything is set to auto.

Anonymous
Not applicable
Author

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
Master II
Master II

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

Learning never stops.
Anonymous
Not applicable
Author

i did try it, no luck !

shraddha_g
Partner - Master III
Partner - Master III

If possible share sample app

sunny_talwar

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

Anonymous
Not applicable
Author

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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