Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE

Line chart conditional coloring (reference line)

whiteline
Master II
Master II

Line chart conditional coloring (reference line)

Sometimes there is a requirement of coloring a line chart depending on some reference value.

Background color expression is not always suitable, because the line segments are colored according to the start point.

As a workaround I suggest to use another approach based on a background image.
Usually it doesn’t contradict with the requirements because the areas above and below are just as important as the reference value.

Shortly it’ can be described in three steps:

 

  1. Background image
  2. Dynamic Min/Max calculation
  3. Dynamic reference calculation

 

These steps are described in the doc.

The sample is also attached.

Attachments
Version history
Revision #:
1 of 1
Last update:
‎2014-01-27 09:44 AM
Updated by: