Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try to color it as follow :
if(len(trim(aggr(Above(Dimension4),ID,Dimension4)))>0,'red')
result :
try to color it as follow :
if(len(trim(aggr(Above(Dimension4),ID,Dimension4)))>0,'red')
result :
Thank you @OmarBenSalem ! This is working as expected.