Highlighting a few changed dimensions in Table Object for rows with same ID value

[sban]

Hi Team,

I have a table object in Qlik Sense of the below format:

ID	Month	Calculated Measure Column: if(aggr(count(....)), 'X','Y')	Dimension4	Dimension5
1	Nov	Y	ABC	QWERTY
1	Dec	Y	ABC1	QWERTY
2	Nov	X	r	y
3	Nov	Y	abc	abc2

I want to highlight ABC1 in some colour, because it is the dimension that has changed in Dec for the same ID. However I would prefer avoiding highlighting the Month. Similarly for other rows that have same ID in this table object.

Is there any way that this can be done through set expressions?

Thanks and Regards.

[OmarBenSalem · Accepted solution]

try to color it as follow : 

if(len(trim(aggr(Above(Dimension4),ID,Dimension4)))>0,'red')

result : 

[sban]

Thank you @OmarBenSalem ! This is working as expected.