topic Re: Unmatched Keys in QlikView

Unmatched Keys

Anonymous — Fri, 13 Jun 2014 10:18:35 GMT

Dear Experts,

I have 3 tables which has the Employee ID common and which is the connector.

Now I want to list the unmatched details across 3 tables based on my key.

Could you please suggest an idea.

Thanks & Regards

Jeba

Re: Unmatched Keys

MK_QSL — Fri, 13 Jun 2014 10:19:18 GMT

Can you provide little sample data?

Re: Re: Unmatched Keys

Anonymous — Fri, 13 Jun 2014 10:24:19 GMT

Hi Manish,

Please find attached the sample data.

I have highlighted the values I want to list.

Kindly help

Thanks & Regards

Jeba

Re: Unmatched Keys

whiteline — Fri, 13 Jun 2014 10:35:43 GMT

Hi.

To check whether particular Employee ID is contained in a table, you can use Employee ID as dimension and count some value from the desired table. If count >0 then Employee ID is contained in the table.

Re: Unmatched Keys

Anonymous — Fri, 13 Jun 2014 10:40:53 GMT

My Employee ID field name is same across 3 tables.How to call the specific?

Re: Re: Unmatched Keys

tresB — Fri, 13 Jun 2014 10:51:31 GMT

May be like attached sample?

Re: Unmatched Keys

whiteline — Fri, 13 Jun 2014 10:56:34 GMT

Actually if the field is common there is only one Employee ID that has indexes in three tables.

Could you just try ? Create chart with one dimension Employee ID and add three count expression that use fields from different tables.

Re: Unmatched Keys

MK_QSL — Fri, 13 Jun 2014 10:57:00 GMT

T1:

Mapping LOAD

Emp_ID & Name as Key,

Emp_ID & Name as Flag

FROM

[EMP Data.xlsx]

(ooxml, embedded labels, table is Table1);

Final:

LOAD

IF(ApplyMap('T1',Emp_ID&Name,'NO')='NO',Emp_ID) as NoEmp_ID,

IF(ApplyMap('T1',Emp_ID&Name,'NO')='NO',Name) as NOName,

Emp_ID,

Name

FROM

[EMP Data.xlsx]

(ooxml, embedded labels, table is Table2);

LOAD

IF(ApplyMap('T1',Emp_ID&Name,'NO')='NO',Emp_ID) as NoEmp_ID,

IF(ApplyMap('T1',Emp_ID&Name,'NO')='NO',Name) as NOName,

Emp_ID,

Name

FROM

[EMP Data.xlsx]

(ooxml, embedded labels, table is Table3);

T2:

Mapping Load

Emp_ID & Name as Key,

Emp_ID & Name as Flag

Resident Final;

LOAD

IF(ApplyMap('T2',Emp_ID&Name,'NO')='NO',Emp_ID) as NoEmp_ID,

IF(ApplyMap('T2',Emp_ID&Name,'NO')='NO',Name) as NOName,

Emp_ID,

Name

FROM

[EMP Data.xlsx]

(ooxml, embedded labels, table is Table1);

======================

Now Create a table box with

NoEmp_ID and NOName as dimension

Presentation tab and select NoEmp_ID and Tick Omit Rows When Field is NULL

Re: Unmatched Keys

Anonymous — Fri, 13 Jun 2014 11:07:23 GMT

Thanks Manish,It worked perfectly