Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditional Text Color or Background based on Expression

Hi All,

I've got a couple of date fields like 'Last Meeting', 'Last Phone Call' etc that i'm trying to have coloured based on conditions.  The first condition is whether another field have either A, B or C - that field is called 'Target Grade'. 

So basically:

If the 'Target Grade' field = 'A' and the 'Last Meeting' or 'Last Phone Call' date is greater than 3 months I would like the date values to turn Red
If the 'Target Grade' field = 'B' and the 'Last Meeting' or 'Last Phone Call' date is greater than 6 months I would like the date values to turn Red
If the 'Target Grade' field = 'C' and the 'Last Meeting' or 'Last Phone Call' date is greater than 12 months I would like the date values to turn Red

Anyone able to get me started?

Thanks, Pri

Community Browser