Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danielburman
Contributor
Contributor

Conditional formatting a cell background

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

 

Labels (1)
1 Reply
danielburman
Contributor
Contributor
Author

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))))))))