Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to get the non matching records and matching records

Hello All,

I have 2 tables assume table A and B in which id is the common filed, I need to compare table A id with B and need to get the non matching records count and matching records count.

Also in table B i have a status column for the id from table A i may have 2 or 3 transaction status and transaction numbers if all the status are passes then that particular should come in passed category if not it should come in failed category in the pivot or straight table created.

Please help me in this.

Thanks in advance

1 Reply
Highlighted
Partner
Partner

Re: How to get the non matching records and matching records

Hi,

Have you tried using the match function.

match function in qlikview