How to compare 2 columns in the table and put not matching results?

[Anonymous]

Count the number of wrong status in compare Group1 and Group2, considering the following exceptions:

Attached the sample data to count

[oknotsen · Accepted solution]

Use the index() function.

Index ‒ QlikView‌

Example:

if(index(column(2), column(1))>0, 'Correct', 'Wrong')

[Anonymous]

Thank you for your answer Onno.

Actually I'm looking for not matching entries (between Group1 and Group2).

[oknotsen]

Change the > to =

[settu_periasamy]

Hi,

i think, already you got answer from okg‌, you just need to change field name instead of column (if you want that in front end you can use the column function)

Directory;

LOAD Group1,

     Group2,

     if(index(Group2, Group1)>0, 'Correct', 'Wrong') as New

FROM

[Sample data.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

Thanks okg and Settu. It works well

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .