Bar Color Based on Calculated Dimension

Mon, 19 May 2014 14:53:06 GMT

Hi,

I have a bar chart with 1 dimension that is a calculated dimension. Specifically,

=Num(floor(Sales,vStdev,vMedian),'$#,##0.00'),

Where Sales is a regular dimension corresponding to a numerical value, vStdev is the standard deviation of Sales, and vMedian is the median of Sales.

My bar chart's expression then counts the number of Sales within each bucket (calculated dimension), i.e.,

count(Sales)

I want to have only the bar corresponding to the median value be green. I am attempting to accomplish this via the 'Background Color' option of my expression with to following expression,

=if(Num(floor(Sales,vStdev,vMedian),'#,##0.00')=Num(vMedian,'#,##0.00'),Green()),

but to no avail.

Any help will be appreciated. I have attached a sample qvw illustrating my problem and desired outcome.

Thanks and best regards,

Ryan

Re: Bar Color Based on Calculated Dimension

Mon, 19 May 2014 19:38:46 GMT

I figured it out. The solution is to use the expression

=if(Num(floor(Avg(Sales),vStdev,vMedian),'#,##0.00')=Num(vMedian,'#,##0.00'),Green())

for 'Background Color'.

topic Bar Color Based on Calculated Dimension in QlikView

Bar Color Based on Calculated Dimension

Re: Bar Color Based on Calculated Dimension