Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
kfir1987
Contributor II
Contributor II

Multi color With Combo Chart

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  

11 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Can you share sample data.

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kfir1987
Contributor II
Contributor II
Author

Unfortunately, no this is confidential info.
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

You can create the same scenario with sample data and share.

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kfir1987
Contributor II
Contributor II
Author

Hi 

The data is:

Machine IDDateUtilizationStatusBatch Numebr
A8/7/201755.9%SUCCESS33176589
A8/7/20170.4%SUCCESS33176581
A8/7/20170.4%SUCCESS33176605
A8/8/2017100.0%SUCCESS33176589
A8/9/201746.1%ERROR33162548
A8/9/201742.7%SUCCESS33176589
A8/10/201783.2%ERROR33162548
A8/11/201764.9%SUCCESS33177816
A8/11/201725.3%ERROR33162548
A8/12/2017100.0%SUCCESS33177816
A8/13/201733.9%SUCCESS33177816
A8/13/201731.2%SUCCESS33151192
A8/14/201798.9%SUCCESS33151192
A8/15/201767.2%SUCCESS33148007

 

Thanks 

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you share screenshot of your current chart.

 

Also let us know what expression you have used for both the measures.

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kfir1987
Contributor II
Contributor II
Author

Bars.png

 

 

 

 

My measure expression is OK and no problem found in the expression. 

My question is how can I change the line color? You can see the line color change accordingly to the bar color. 

The color expression that I created mentioned in my first post.  

 

agigliotti
Partner - Champion
Partner - Champion

I guess you can't have different color by expression for both measures.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

 

You should create the line expression as master measure and then assign the color of your choice to it.

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kfir1987
Contributor II
Contributor II
Author

Hi,

I already did it but when expression define on VIEW level, then Qlik will ignore the measure color that defines on a master item level.
Thanks