topic Compare 2 qvd files in QlikView

Compare 2 qvd files

Alf — Fri, 26 Feb 2021 20:26:52 GMT

There are 2 qvd files (QF1,QF2), both with ID field as primary key. I want to know how many ID values are in:

> QF1 that are not in QF2 (QF1 - QF2)
> QF1 and QF2 (QF1 ^ QF2)
> QF2 that are not in QF1 (QF2 - QF1)

I would appreciate any help in this regard.

Greetings, ALF.

manoranjan_d — Fri, 26 Feb 2021 20:41:13 GMT

While loading ur data use the wher cond

QF1 that are not in QF2 (QF1 - QF2)

Use where not exist(primary key)

QF1 and QF2 (QF1 ^ QF2)

Use where exist(primary key)

QF2 that are not in QF1 (QF2 - QF1)

Use where not exist(primary key)