topic Compare two files in QlikView

Compare two files

spividori — Wed, 21 May 2014 12:00:42 GMT

Hi.

I have this model and I need to compare the amounts of object 1 vs Rubro2 when they are equal.

This is a small example of my model, I could establish a link between Vend and heading, but in my original model more complex and need to do it this way.

Regards.

Re: Compare two files

alexandros17 — Wed, 21 May 2014 12:05:57 GMT

Ecco il miol esempio, guarda "MY TABLE"

Re: Compare two files

its_anandrjs — Wed, 21 May 2014 12:05:59 GMT

Is there any problem if you take this table in single table like with join of left join for comparing the fields.

Re: Compare two files

jonathandienst — Wed, 21 May 2014 12:07:23 GMT

When I need to do this type of comparison, I concatenate the sets into a single fact table with a source field to indicate the original data source. It is then very easy to compare. So the load would be like:

Data:

LOAD *,

'Tbl1' As Source

FROM Tbl1;

Concatenate

LOAD *,

'Tbl2' As Source

FROM Tbl2;

Then to compare, create a straight or pivot table with Vend as the dimension and for the expressions (to compare field Rubro):

Tbl1 =Sum({<Source = {'Tbl1'}>} Rubro)

Tbl2 =Sum({<Source = {'Tbl2'}>} Rubro)

Diff =Column(1) - Column(2)

HTH

Jonathan

Re: Compare two files

spividori — Wed, 21 May 2014 12:34:03 GMT

Thanks for responding, but would not it be done with Set Analysis directly?

Regards.