12 Replies Latest reply: Jan 27, 2018 6:17 AM by Shoaib Ahmed RSS

    Qlik Sense - Set Analysis Ignore field does not work properly

    Shoaib Ahmed

      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