topic Re: COUNT in QlikView

COUNT

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,I want not matched count between two tables

I have tables like

CDMS

T2:

Output:

T1:

Count is 2

Output:

T1:

Count is 4

How can i get this is it possible in qlikview

Gysbert_Wassenaar — Wed, 21 Sep 2016 06:51:45 GMT

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 — Wed, 21 Sep 2016 07:04:25 GMT

Hi Bro,

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

but you given like this

Gysbert_Wassenaar — Wed, 21 Sep 2016 07:08:48 GMT

wfm

qlikview979 — Wed, 21 Sep 2016 07:16:18 GMT

Thanks Bro,

its working....

Regards,

Mahesh