Need expert advice : Conditional Bar Chart Colour Expression

Wed, 20 Feb 2013 08:35:03 GMT

Hi All,

I posted a while back for some help on how to format an individual bar to a certain colour based on a conditional expression. Unfortunately I was unable to get help and still have this problem.

My expression in the 'background colour' for my expression is the following

if(

(sum({<CalendarMonthAndYear={'>=$(v12MonthMin)<=$(v12MonthMax)'}>}Cost)+

sum({<CalendarMonthAndYear={'>=$(v12MonthMin)<=$(v12MonthMax)'}>}HistoricCostTrendCost))=

MaxString(

RangeMax(

Max(TOTAL aggr(sum({$<CalendarMonthAndYear={'>=$(v12MonthMin)<=$(v12MonthMax)'},CallType={'o'}>}Cost),CalendarMonthAndYear)),

Max(TOTAL aggr(sum({$<CalendarMonthAndYear={'>=$(v12MonthMin)<=$(v12MonthMax)'}>}HistoricCostTrendCost),CalendarMonthAndYear)))),red(),green())

This expression

sum({<CalendarMonthAndYear={'>=$(v12MonthMin)<=$(v12MonthMax)'}>}Cost)+

sum({<CalendarMonthAndYear={'>=$(v12MonthMin)<=$(v12MonthMax)'}>}HistoricCostTrendCost)

is the actual expression that sums up the cost for each calendarmonthandyear (i have this as the dimension in the bar chart). So my conditional expression says when the sum of that value equals the max aggregated value over the whole term, then colour that. My output is always green for every bar.

I think its cause I need to aggregate again to ensure that it is still not doing it by calendarmonthandyear, but not sure how I would get this to work. Individually both expressions work great. The maxstring gives me in a text box the value I am looking for, so why can't this in the conditional give me the same result. my thinking says thats its because in my chart I have used calendarmonthandyear as the dimension. Anyway, if anyone knows what I am doing wrong, please help me out

Thanks,

Byron

Re: Need expert advice : Conditional Bar Chart Colour Expression

Wed, 20 Feb 2013 13:01:42 GMT

bump! comeon guys, there must be someone that knows how to do this

Cheers,

Byron

Re: Need expert advice : Conditional Bar Chart Colour Expression

sushil353 — Mon, 25 Feb 2013 09:15:29 GMT

is it possible to upload the sample application.

Re: Need expert advice : Conditional Bar Chart Colour Expression

sunilkumarqv — Wed, 05 Mar 2014 12:55:36 GMT

Can you make it simple Question?

topic Need expert advice : Conditional Bar Chart Colour Expression in QlikView

Need expert advice : Conditional Bar Chart Colour Expression

Re: Need expert advice : Conditional Bar Chart Colour Expression

Re: Need expert advice : Conditional Bar Chart Colour Expression

Re: Need expert advice : Conditional Bar Chart Colour Expression