How to highlight a value that is dependent on another value

[ShaunJMD]

I'm trying to highlight values in the Job column that matches the Dependency Column where the status is equal to red.

In the first image, I have a list of jobs,  the job's status and it's dependency. So if a Job's status is 'red' and it has a dependency, it should highlight the job that equals the  dependency value.

I have tried several different expressions, but none gives me the result I want to display.

I've tried if(WildMatch(Job, '*' & [Dependency] & '*'), RGB(0, 255, 255)) but it doesn't seem to work

 

The output that I am looking for can be seen below

[miguelbraga · Accepted solution]

Hey there,

Perhaps consider this script code:

Table:
LOAD * INLINE [
    Job, Status, Dependency
    A, Green, J
    B, Green, C
    C, Red, D
    D, Green
    E, Green
    F, Green, H
    G, Green, F
    H, Green
    I, Red, K
    J, Green,
    K, Green,
    L, Red, A
];

left join

LOAD
 Dependency as Job,
 'Blue' as ColoringCode
Resident Table
Where Status = 'Red';

Then use this expression in the Background color:

=if(not isnull(ColoringCode), RGB(0, 255, 255))

After that, please see the following result:

Please refer to the attached qvw file.

Best regards in the hope this helped you,

MB