Multi color With Combo Chart

[kfir1987]

Hi, 

I have combo chart in my dashboard that contains columns and line 

The dimension is date and the measures are number of jobs and utilization. 

I want to paint the column (utilization measure)  in red when job defined as Error (completion status field) , in any other cases I want to paint the column in blue. 

But I want to paint the line in yellow at any time ( not based on completion status) .

So I wrote the below script, but it paints both of the measure indications :

if([Completion Status] = 'ERROR',rgb(237,140,154) ,rgb(150,194,237))

There is any way to do it ? 

Thanks  

[Melissa_Potvin]

is this thread for QlikView or Qlik Sense? I'd like to move your question to the correct product board. Please use tags to assist. Thanks!

[kfir1987]

Qlik Sense