Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

qlikviewforum
Contributor II

Comparing the existing and new excel and highlight the difference!

Hi,
I want to compare the data of existing excel and new excel side by side and highlight the difference. The column name of the existing and new excel will be same. Only values may be different. I want to highlight only those columns which are different from the existing one using a QV document.

Can someone please help me out on this?

Thanks in advance!

Tags (2)
2 Replies

Re: Comparing the existing and new excel and highlight the difference!

Let's say the first excel file is X1, and the second is X2.

When you load add a field:

Load

  *,

  'X1' as fileNum

From .... (From X1)

concatenate

Load

  *,

  'X2' as fileNum

From .... (From X2)

Now you have une table containing both files values,the values comeing from the first one are marked with X1, from the secont with X2

Build a chart where expression are built in this way

Expression1: Sum({$<fileNum={'X1'}>} myValue) this is from X1

Expression2: Sum({$<fileNum={'X2'}>} myValue) this is from X2

Now you have 2 expression (Add your dimension) side by side as you need

qlikviewforum
Contributor II

Re: Comparing the existing and new excel and highlight the difference!

I don't have values in the any of the columns. All are text only. Please suggest!