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

sandeepprasad_j — Mon, 16 Sep 2013 06:08:01 GMT

HI Experts.

Below is the image i am having

I have to change it to

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.

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

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