Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Spent some time playing and it may not be the most elegant solution but this seems to do the job
if(Status='On track',RGB(83,129,53),if(Status='Slight delay',RGB(255,255,0),if(Status='Off track',RGB(255,192,0),if(Status='Delayed',RGB(255,0,0),if(Status='Not started',RGB(217,217,217),if(Status='On hold',RGB(166,166,166),if(Status='Completed',RGB(0,112,192))))))))