3 Replies Latest reply: Feb 14, 2017 9:48 AM by Prasanna Chandran RSS

    Join Two Data sets in Qliksense

    Prasanna Chandran

      I have two data sets.

       

      Data Set 1:

      ID | Data Field 1

      1 | X1

      2 | X2

      3 | X3

       

      Data Set 2:

      ID | Data Field 2

      1 | Y1

       

      In QS I am linking the two data sets on Key being the field 'ID'.  When I view this in QS I will see as follows.

       

      ID | Data Field 1 | Data Field 2

      1 | X1 | Y1

      2 | X2 | -

      3 | X3 | -

       

      I want to view the records that were present in Data Set 1, but not in Data Set 2. i.e. The result should show.

      ID | Data Field 1 | Data Field 2

      2 | X2 | -

      3 | X3 | -

       

      Is there a way to do it? I have tried the Isnull (Data Field 2) option to set a flag in a new dimension and it does not work. This works in a measure field, but derived Measure fields cannot be filtered. Please let me know if there is a way to do this.