topic individual Chart bar colors in QlikView

individual Chart bar colors

dhborchardt — Sun, 20 Mar 2011 14:08:56 GMT

Can each bar(Month) on a chart have a different color depending on its level. For example I have attached what I have so far.

The total Diagnoses should always be purple. The total POA for each month should be Green, Red or Yellow depending on its level. If below 2-green, if 3 - yellow, if above 3 - Red.

Diagnoses - all the individual diagnoses per month

PAA - Patients that had the infection Present On Admission.

Goal - 3 or less Hospital aqired infections

Caution - between 2 and 3 infections

individual Chart bar colors

dhborchardt — Sun, 20 Mar 2011 15:04:05 GMT

I found the answer thanks to the QlikView Maven.

http://qlikviewmaven.blogspot.com/2009/02/highlighting-chart-value.html

Right-click on the chart and select Properties and go to the Expressions tab. Click on the little plus sign ( + ) to the left of the expression you want to highlight. See the example in the picture above. In the example, the expression is named Shipments and I have clicked on the Background Color choice and entered this expression into the box:

IF(Count ({$<POA={N}>}POA) < 4, Green(),Red())