Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
dhborchardt
Partner - Creator
Partner - Creator

individual Chart bar colors

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

Labels (1)
1 Solution

Accepted Solutions
dhborchardt
Partner - Creator
Partner - Creator
Author

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())

View solution in original post

1 Reply
dhborchardt
Partner - Creator
Partner - Creator
Author

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())