3 Replies Latest reply: Apr 18, 2018 3:19 AM by Xavier HEMELAAR RSS

    Show Excluded

    Xavier HEMELAAR

      Hi Qlikers,

       

      I would like to display in a table the list of excluded values. Data looks like this:

        

      Extract_DateProjectCatInfo
      15/04/2018A1A1
      16/04/2018A1A2
      17/04/2018A1A3
      18/04/2018A1A4
      19/04/2018A1A5
      20/04/2018A1A6
      21/04/2018A2A7
      22/04/2018A2A8
      23/04/2018A2A9
      24/04/2018A2A10
      25/04/2018A2A11
      26/04/2018A2A12
      27/04/2018A2A13
      28/04/2018A2A14
      29/04/2018A2A15
      30/04/2018A2A16
      15/04/2018B1B1
      16/04/2018B1B2
      17/04/2018B1B3
      18/04/2018B1B4
      19/04/2018B1B5
      20/04/2018B1B6
      21/04/2018B1B7
      22/04/2018B1B8
      23/04/2018B1B9
      24/04/2018B1B10
      25/04/2018B1B11
      26/04/2018B1B12
      27/04/2018B1B13
      28/04/2018B1B14
      29/04/2018B1B15
      30/04/2018B1B16

       

       

      If I filter on Project = A, Cat=1 I get this:

        

      Extract_DateProjectCatInfo
      15/04/2018A1A1
      16/04/2018A1A2
      17/04/2018A1A3
      18/04/2018A1A4
      19/04/2018A1A5
      20/04/2018A1

      A6

       

      But what I would like to display is what is excluded:

       

        

      21/04/2018A2A7
      22/04/2018A2A8
      23/04/2018A2A9
      24/04/2018A2A10
      25/04/2018A2A11
      26/04/2018A2A12
      27/04/2018A2A13
      28/04/2018A2A14
      29/04/2018A2A15
      30/04/2018A2A16

       

       

      How do I get this ?

       

      Thanks for your help