3 Replies Latest reply: Jul 20, 2018 7:25 AM by Pablo Labbe RSS

    Qlik Sense, load data only exists in colomn1 but not exists in colimn2

    Xu Zhao

      Hi :

      I want to load data only exists in colomn1 but not exists in colimn2

       

      my example is :
      ID          Date1                  Date2

      1           06/07/2018         01/01/2018

      2          06/08/2018         02/02/2018

      3           13/01/2012         13/09/2011

      4           13/09/2011         30/05/2020

      5           30/05/2020         13/01/2012

       

       

      so I only want to load the data exists in Date2 , but not exists in Date1

       

      should be like :

      ID          Date1                  Date2

      1           06/07/2018         01/01/2018

      2          06/08/2018         02/02/2018