Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Join Two Data sets in Qliksense

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.

3 Replies
ogster1974
Honored Contributor II

Re: Join Two Data sets in Qliksense

Add a third field to your data sets called source and name the value data set 1 and data set 2 you will then be able to satisfy both your conditions.

Hope this helps

Andy

aarkay29
Valued Contributor

Re: Join Two Data sets in Qliksense

May be this,

[Data Set 1]:

LOAD * INLINE [

ID,Data Field 1

1,X1

2,X2

3,X3

];

INNER JOIN ([Data Set 1])

Table2:

LOAD * INLINE [

ID,Data Field 1

1,Y1

];

LOAD *,

IF(IsNull(F2),1) AS [NULL FLAG]

RESIDENT

  [Data Set 1];

DROP TABLE

  [Data Set 1];

SELECT THE DIMENSION,[NULL FLAG ]=1 SHOULD GIVE YOU THE DESIRED RESULT

Not applicable

Re: Join Two Data sets in Qliksense

If i do that it would look like this.

ID | Source

2 | DS1

3 | DS1

What will be the value of Source field for ID: 1?

If I apply filter on Source = DS1 will I get only 2 and 3?