How to apply table conditions

Fri, 05 Feb 2016 10:16:31 GMT

Hi there,

I wonder if you can help.

I have a table like below:

Dependency Name	RAG Status	Dependent on Task:
dependency 1		Task 1

I have another table that says:

Task Name	RAG Status
Task 1	Red

I would like to be able to say "IF TaskTable.Task1 = 'RED' then DependencyTable.Dependency1 should equal red AND the cell should turn red accordingly

Can you help?

topic How to apply table conditions in QlikView