Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
sandeepprasad_j
Creator
Creator

Help in changing the bar colors in combo chart???

HI Experts.

Below is the image i am having

Original.jpg

I have to change it to

Bar.jpg

Presently i am using the original expression as

sum({<Year=,[Month Name Short Year]=,date_con ={'>=$(=addmonths(max(date_con),-5))<=$(=max(date_con))'},[Metric_ID] ={'qq_001'} >} Result)/1000

To change the bar colors i had done with the following changes as below

So ,to do this i had gone to the Properties -->Expressions Tab--->Under each Expression --->Clicked on Background Color

So by changing the above expression , i am using the below expression in background color expression  as

if(sum({<Year=,[Month Name Short Year]=,date_con ={'>=$(=addmonths(max(date_con),-5))<=$(=max(date_con))'},[Metric_ID] ={'qq_001'} >} (Result)/1000)>> 50,blue(),red())

But i am not getting the answer to change the bar colors

Please help me asap

Thanks in advance

Regards ,

Sandeep.

0 Replies