topic Re: Data comparison (find differences between 2 sets of data) in QlikView

Data comparison (find differences between 2 sets of data)

pennetzdorfer — Wed, 01 Apr 2015 13:26:19 GMT

Hello,

I'm looking for a way to compare 2 similar sets of data and highlight the differences (maybe similar to tools like WinMerge, Kompare etc.? ... see Screenshots below).

I'm not really sure how to start that project - does anyone have experience / tips / examples / links / tutorials for me?

Any help is appreciated!

Scenario:

We try to set up a Version Control for our Bills of Material (BOM).
A user should be able to select 2 similar BOMs and then check the differences.
There are different types of BOM-changes (changed value, deleted row, new row, ...)
A standard BOM contains up to 500 rows and about 50 columns.
Comparison cannot be done in script because users should compare ANY BOMs they want.
So I need some kind of visualization (straight table) that shows the differences (colors, symbols etc.)

Regards, Florian

PS: Screenshot of "WinMerge" and "Kompare"

Re: Data comparison (find differences between 2 sets of data)

hannan_t — Tue, 07 Apr 2015 08:42:52 GMT

Hi Florian,

You can use Alternate State functionality of qlikview in order to perform comparative analysis.

please see the following thread for reference.

what is alternate states in Qlikview ?

Re: Data comparison (find differences between 2 sets of data)

pennetzdorfer — Tue, 07 Apr 2015 09:10:24 GMT

Hi Hannan,

I also considered Alternate State, but can't figure out how it could help me.

As far as I understand, Alternate State allows to make 2 (or more) groups of selections. But selections are not the problem in my case.

My question is rather targeted on how to visualize the differences.

Regards,

Florian

Re: Data comparison (find differences between 2 sets of data)

pennetzdorfer — Mon, 20 Apr 2015 13:29:13 GMT

Anyone got an idea?