Require a pivot report where changes data gets highlighted

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a requirement where i need to compare the data from one category with another category and display rows only where there is a change. However display with the new data only. And this is for 12 months of data. So even if single month changes i need to show that as highlighted one.

Example:

Table A / Table B : Table A and Table B are loaded as separate tables.

Col1 , 2 , 3 are the base columns for which there will be a HCM value for 12 months Jan to Dec. in both tables A and B.

TABLEA

ACol1	Col2	Col3	DEC	JAN	FEB
A	B	C	2	4	6

D	E	F	3	2	7
G	H	I	2	3	3

TABLEB

ACol1	Col2	Col3	DEC	JAN	FEB
A	B	C	5	4	6

D	E	F	3	4	7
G	H	I	2	3	3

RESULT: Row 1 and 2 are shown and the one which has changed value is highlighted. Note I do not need the difference , but where there is a difference i need the value from Table B. Like 5 - 2 > 0 , so show 5 from table B. Please let me know which is the best approach for this either via formula in Pivot table or via script or any other simple method.

ACol1	Col2	Col3	DEC	JAN	FEB
A	B	C	5	4	6

D	E	F	3	4	7

topic Require a pivot report where changes data gets highlighted in QlikView

Require a pivot report where changes data gets highlighted