2 Replies Latest reply: Oct 5, 2016 6:07 AM by fredrik olsson RSS

    Set expression and filtering

    fredrik olsson

      Hi,

       

      When I apply a filter to show number of order for a certain week some KPI outside the selection are still visible and not blanked out. Is this by design in Qlik Sense or am I doing something wrong?

       

      OrderIdOrderWeekTotal
      54637299
      54737549
      68938499
      69038495
      69138399

       

      If I apply a filter to only show OrderWeek = 37 then the set expression:

      COUNT({ $<OrderWeek={'38'}>} OrderId) doesn't get blanked out.