Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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())
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())