Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted

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.

Highlighted
Creator
Creator

No . Everything is set to auto.

Highlighted
Creator
Creator

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.

Highlighted
Master II
Master II

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

Learning never stops.
Highlighted
Creator
Creator

i did try it, no luck !

Highlighted
Partner
Partner

If possible share sample app

Highlighted

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

Highlighted
Creator
Creator

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.

Highlighted
MVP & Luminary
MVP & Luminary

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