COUNT

[qlikview979]

Hi Experts,I want not matched  count between two tables

I have tables like

T1

CDMS

1

2

3

4

5

T2:

ZY

1

2

3

6

7

8

9

Output:                         

T1:                                   

4                                       

5                                       

Count is 2

Output:                         

T1:                                   

6

7

8

9

Count is 4

How can i get this is it possible in qlikview

[Gysbert_Wassenaar]

T1:

LOAD CDMS FROM ...somewhere...;

T2:

LOAD ZY FROM ...somewhere_else...;

T3:

LOAD CDMS as CDMS_NOT_IN_ZY RESIDENT T1 WHERE Not Exists(ZY, CDMS);

LET Count_CDMS_NOT_IN_ZY = FieldValueCount('CDMS_NOT_IN_ZY');

T4:

LOAD ZY as ZY_NOT_IN_CDMS RESIDENT T2 WHERE Not Exists(CDMS,ZY);

LET Count_ZY_NOT_IN_CDMS = FieldValueCount('ZY_NOT_IN_CDMS');

[qlikview979]

Hi Bro,

I think its not work because CDMS  in T1 Table ,ZY  as T2 tablr

but you given like this

• LOAD CDMS as CDMS_NOT_IN_ZY RESIDENT T1 WHERE Not Exists(ZY, CDMS);
• 
  
• Regards
• Mahesh
  

[Gysbert_Wassenaar · Accepted solution]

wfm

[qlikview979]

Thanks Bro,

its working....

Regards,

Mahesh