topic Compare 2 columns & display unique values in QlikView

Compare 2 columns & display unique values

Fri, 10 Feb 2012 17:26:53 GMT

Hi,

I have a file with 2 non-identical columns: A & B. Each entry in Column A has an entry somewhere in Column B. I want to display a list of entries that will compare all the entries in A with those in B and only display those that are missing from B.

In Excel this works:

=IF(COUNTIF(B:B,A2)=0,A2,"")

I have attached a sheet containing some dummy data and the excel formula working correctly.

Any help would be greatly appreciated...

Thanks

Compare 2 columns & display unique values

Anonymous — Fri, 10 Feb 2012 18:48:01 GMT

Hi A,

Try this in your script:

Data:

LOAD [Column A],

[Column B],

If (ISNULL([Column B]) , [Column A]) as [Column C]

FROM

[..\QV Missing IDs.xls]

(biff, embedded labels);

Good luck,

Dennis.

Compare 2 columns & display unique values

Fri, 10 Feb 2012 19:32:51 GMT

Hi Dennis,

That works perfectly, thanks.

Alan

Compare 2 columns & display unique values

Mon, 13 Feb 2012 08:50:32 GMT

Hi Dennis,

How would I do this if the two fields that I want to compare are in two different tables?

Thanks

Alan

Compare 2 columns & display unique values

CELAMBARASAN — Mon, 13 Feb 2012 08:58:42 GMT

Hi,

Use Exists(FieldName) in the Where clause.

Field name should be common in both the table.

Hope it helps

Celambarasan

Compare 2 columns & display unique values

Mon, 13 Feb 2012 09:16:47 GMT

Hi Celambarasan,

Thanks very much for your prompt response.

Would you mind specifying how this would be incorporated into the script?

I am very new to Qlikview...

Cheers

Alan