Row Level Match In Qlikview

[rahulsingh12]

Hi,

I have two table namely A and B.

Both the tables have same number of columns and same column name.

Table A contain version1 data and Table B contains version2 data.

A:

version      Vendor     Region     Core                    Amount

1                    A          North         North-East          100

1                    B          South        South-West         100

B:

version      Vendor     Region     Core                    Amount

2                   A          East          East                     100

2                   B          South        South-West         100

I want to compare row level data for each vendor ,for each version if it matches then yes else no.

Output:

version      Vendor     Region     Core                    Amount

1                    A           North         North-East          100

2                    A           East          East                     100

                                    No             No                       yes

1                   B           South        South-West         100

2                   B           South        South-West         100

                                   Yes          Yes                         Yes

how can I achieve this row level comparison in Qlikview?

Regards,

[rahulsingh12]

hi,

i won't be able to find out exactly in which column do I have the mismatch.

Regards,

Rahul

[effinty2112]

Hi Rahul,

Try this pivot table

Vendor	Field	Mismatch
A	Core	X
	Region	X

Where

Field is the calculated dimension =if(not match($Field,'Vendor','version'),$Field)

and Mismatch = if(count(Distinct Pick(match($Field,'Amount','Core','Region'),Amount,Core,Region))>1,'X')

good luck

Andrew

[rahulsingh12]

Hi Guys,

Any update on using a for loop to  loop through the fields in the table.

Regards,

Rahul

[balar025]

Here is the file which you can use for dynamic comparison.

[rahulsingh12]

Hi,

I have attached a file which compares the data of each row with its previous value.

Regards,

Rahul