topic QlikView Data Analysis in QlikView

QlikView Data Analysis

Fri, 20 Nov 2020 18:02:30 GMT

Hello Everyone,

My query is related to joining two datasets in QlikView and split out the difference

I have two datasets (example, see below). I would like to join this two datasets to check if the employee in dataset #1 is setup in second list or not. If not then my result should just fetch Joe Miller as result because that is the only emplyee which is not present.

How do you do this in QlikView? Please note, I tried to join these two tables in QlikView but the data displayed a result is a combined view which means all the entries in Dataset are displayed which is not what I want. My requirement is to view the difference from Dataset #1 point of view.

DataSet #1

Name	Department
Mark Stapleton	Energy
Joe Miller	Finance

DataSet #2

Name	Department
Mark Stapleton	Energy
Tim Cook	Marketing
Nigel Short	Marketing
Mark Fowler	Finance
Paul Leigh	Finance
Andrew Waller	Finance

Thanks for the help.

Re: QlikView Data Analysis

Gysbert_Wassenaar — Mon, 31 Mar 2014 16:43:08 GMT

See attached qvw.

Re: QlikView Data Analysis

maxgro — Mon, 31 Mar 2014 18:48:44 GMT

in script you can

Table2:

load *, Name & '-' & Department as NamDep;

LOAD * INLINE [

Name, Department

Mark Stapleton, Energy

Tim Cook, Marketing

Nigel Short, Marketing

Mark Fowler, Finance

Paul Leigh, Finance

Andrew Waller, Finance

];

Table1:

load *

where not exists(NamDep, Name & '-' & Department);

LOAD * INLINE [

Name, Department

Mark Stapleton, Energy

Joe Miller, Finance

];

DROP table Table2;