Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

Dynamically colored area chart

Hi guys,

I would like to create the area chart with dynamically colored segments in Qlikview. It seems to be impossible. Are there any suggestions?error loading image

Thanks.

Valera

3 Replies
Highlighted
Contributor

Dynamically colored area chart

Hi,

I've used the method outlined by John Witherspoon in this post http://community.qlik.com/forums/t/37654.aspx to fill in a colour between two lines by creating a stacked area chart with the second expression showing the variance from the first expression (which has a white background).

However, only one colour will apply to the whole area per expression.

You could also try a Radar Chart which has an 'overlayed' sub type in the Style tab. If you make the first expression, the target, a red colour and the second overlay a transparent lighter colour it makes areas below target stand out a bit like your requirement.

Another alternative might be to show the varaiance as a bar chart and use an expression in the background colour to set values above 0 to green and below 0 to red,

Regards,

HD

Highlighted
Honored Contributor II

Dynamically colored area chart

Aside from the excellent suggestions above, another possibility is to create multiple expressions, one for each color, and then use set analysis or IF statements to plot the relevant segments in the relevant areas. This might get to be a hassle, but if you don't have too many colors, it shouldn't be too bad.

Regards,

Highlighted
Contributor II

Dynamically colored area chart

Thanks, Vlad,

indeed I'm working on a solution to interpolate between points that cross zero in order to have a point at zero. Because otherwise the two expressions draw wrong areas.

The idea is taken from here:

http://peltiertech.com/WordPress/area-chart-invert-if-negative/

If I have any positive results I will post it here.

Valera 🙂