topic Re: difference highlight with any color? in QlikView

difference highlight with any color?

Anonymous — Sun, 26 Apr 2015 06:37:21 GMT

Hi experts ,

there is one req like

i am attaching excel file (sourcefile) and qvw

now my req is both sheets having same fields and data also 50% is matching

now my req is i want compare data between two sheets (row wise comparision) and and that difference data i want highlight in red color?

unmatched data between 2 sheets i want highlight with red color

PFA

Re: difference highlight with any color?

Sun, 26 Apr 2015 07:10:52 GMT

Else,

You can try like below for said requirement,

PFA

Re: difference highlight with any color?

Anonymous — Sun, 26 Apr 2015 07:32:05 GMT

Hi Thanks for the replu

it is not comparing row wise

Should be some other

Re: difference highlight with any color?

Sun, 26 Apr 2015 08:10:20 GMT

Hi,

May be it will match with your requirement.

If no explain in little bit more..

Re: difference highlight with any color?

stevedark — Sun, 26 Apr 2015 08:26:44 GMT

First you want to load both tables, flagging which data has come from where;

Data:

LOAD

'T1' as Table,

AREA,

ID,

VALUE,

BUSINESS

FROM C:\Users\MANOJKUMAR\Desktop\DATA.xlsx

(ooxml, embedded labels, table is Sheet1);

Do the same for Table 2, with a CONCATENATE (rather than a NOCONCATENATE as you presently have).

You can then create a table with VALUE and BUSINESS as Dimensions and expressions for T1 and T2 done with Set Analysis

sum({<Table={'T1'}>}VALUE)

and

sum({<Table={'T2'}>}VALUE)

You can then create a third column with the variance:

sum({<Table={'T2'}>}VALUE) / sum({<Table={'T1'}>}VALUE)

The colour you need to add to the Background Colour property of the third expression (by clicking on the plus symbol. The code will be something like:

=if(sum({<Table={'T1'}>}VALUE) <> sum({<Table={'T2'}>}VALUE)), rgb(255,100,100), null())

Hopefully that will give you what you need to make this work for you.

Steve