Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Compare 2 columns & display unique values

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

A

1 Solution

Accepted Solutions
dennisnet
Not applicable

Compare 2 columns & display unique values

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.

5 Replies
dennisnet
Not applicable

Compare 2 columns & display unique values

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.

Not applicable

Compare 2 columns & display unique values

Hi Dennis,

That works perfectly, thanks.

Alan

Not applicable

Compare 2 columns & display unique values

Hi Dennis,

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

Thanks

Alan

celambarasan
Not applicable

Compare 2 columns & display unique values

Hi,

     Use Exists(FieldName) in the Where clause.

     Field name should be common in both the table.

Hope it helps

Celambarasan

Not applicable

Compare 2 columns & display unique values

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