9 Replies Latest reply: Apr 30, 2018 8:48 AM by William Fu RSS

    "Keep" filter selections after clearing

    William Fu

      Let's say I'd like to filter the sample table below for all the ID's that had were late on 01/01/2018.

       

      DateIDStatus
      01/12/2017APending
      01/12/2017BPending
      01/12/2017CPending
      01/01/2018ALate
      01/01/2018BOn Time
      01/01/2018CLate
      01/02/2018ALate
      01/02/2018BOn Time
      01/02/2018COn Time
      01/03/2018AOn Time
      01/03/2018B

      On Time

       

      The steps to do it manually in Qlik are pretty straightforward:

      1. Filter Status = 'Late' and Date='01/01/2018'

      2. Filter eligible IDs (A and C)

      3. Clear selections on Status and Date fields to get the required rows:

       

      DateIDStatus
      01/12/2017APending
      01/12/2017CPending
      01/01/2018ALate
      01/01/2018CLate
      01/02/2018ALate
      01/02/2018COn Time
      01/03/2018AOn Time


      I'm looking for a way to do this without the manual steps, where the user can just choose the desired date and status and view the filtered table.

      I can't seem to figure out how to apply these filters a measure without including unwanted data


      The SQL analogy would be:

      SELECT * FROM Table WHERE ID IN (SELECT ID FROM Table WHERE Date = '01/01/2018' AND Status = 'Late')