Hi,
I have been asked to add some conditional formatting to a qlikview report based upon the value in a cell in straight and pivot tables. I have managed to get it to work using 2 values but we have 7. The table should be:
KPI ID | Owner | Oversight | Status |
1 | Jon S | Pal T | On track |
2 | Deb C | Dev P | Slight delay |
I have got this to work: =if(Status='On track', RGB(0,112,192)) or =if(Status='Slight delay', RGB(0,112,192)) but we have 7 different status' each with its own RGB colour
When I try this everything stops working
=if(Status = 'On track', RGB(83,129,53)or
if(Status ='Slight delay', RGB(255,255,0)or
If(Status ='Off track', RGB(255,192,0)or
if(Status ='Delayed', RGB(255,0,0)or
If(Status ='Not started', RGB(217,217,217)or
if(Status ='On hold', RGB(166,166,166)or
If(Status ='Completed', RGB(0,112,192))))))))
Any help gratefully received
Dan
