topic Re: Re: Conditional coloring to line chart based on reference line in line chart in QlikView

Conditional coloring to line chart based on reference line in line chart

Wed, 22 Jan 2014 13:08:10 GMT

Hi,

I have a line chart where I am using reference line. what I need to do in chart is Lines which are above reference 0 should be red & lines below should be green. I am attaching a test report so you might get a better idea.

Thanks

Re: Conditional coloring to line chart based on reference line in line chart

whiteline — Wed, 22 Jan 2014 13:54:04 GMT

Hi.

You can't do it directly.

The line and color belongs to the data point (the start of the segment).

The only way is to calculate the middles and add zero point appropriately.

The solution depends on weather you want to use continuous x-axis or not.

Re: Conditional coloring to line chart based on reference line in line chart

Thu, 23 Jan 2014 06:01:36 GMT

Hi,

Thanks for your reply... Adding zero points will be like adding dummy records which is not a comfortable way to have.

Can we have background of chart like background above 0 will be of red color & below it can be green? Color doesn't matters just distinguishing areas above & below reference lines needed. Any help?

Thanks

Re: Re: Conditional coloring to line chart based on reference line in line chart

Thu, 23 Jan 2014 08:13:33 GMT

Hi,

You can do something like this

Please find the attached file...

Re: Re: Conditional coloring to line chart based on reference line in line chart

Thu, 23 Jan 2014 08:20:22 GMT

Or, maybe like this...

Re: Conditional coloring to line chart based on reference line in line chart

Thu, 23 Jan 2014 08:57:25 GMT

Hi,

Thanks but position of reference line will chages depending on the data.

Ex: depends on customer filter data changes and so position of reference line changes. So I can't go with putting text boxes on background.. Any other workaround?

Thanks

Re: Conditional coloring to line chart based on reference line in line chart

whiteline — Thu, 23 Jan 2014 20:17:15 GMT

Hi.

You can try to use a background image with two areas of equal height.

Then set the expressions for Min/Max properly. They should be equal modulo and change dynamically according to the data selected.

Re: Conditional coloring to line chart based on reference line in line chart

Fri, 24 Jan 2014 09:42:43 GMT

Hi,

Can you please give a sample report ?.. it will give me better understanding.

Thanks

Re: Re: Conditional coloring to line chart based on reference line in line chart

whiteline — Fri, 24 Jan 2014 11:08:33 GMT

Hi.

Something like this.

Notice expressions for min and max.

Re: Conditional coloring to line chart based on reference line in line chart

Fri, 24 Jan 2014 12:14:19 GMT

Hi,

This solution is good when reference axis is not moving .. but with my data reference axis is moving... sometimes if there are all -ve values then reference line appear at top with no +ve values on y-axis.. so this solution has limited scope in my scenario.. Any other suggestion?

Re: Conditional coloring to line chart based on reference line in line chart

whiteline — Fri, 24 Jan 2014 12:23:31 GMT

Hi.

If you know the reference value it's not hard to apply linear transformation to the min/max expressions so that the boundary match the reference line.

Re: Conditional coloring to line chart based on reference line in line chart

whiteline — Mon, 27 Jan 2014 14:57:56 GMT

http://community.qlik.com/docs/DOC-5762

Re: Conditional coloring to line chart based on reference line in line chart

ThornOfCrowns — Mon, 27 Jan 2014 15:06:06 GMT

Nice work, many thanks.

Re: Conditional coloring to line chart based on reference line in line chart

Tue, 28 Jan 2014 05:34:01 GMT

Thanks a lot .. !!!

Re: Conditional coloring to line chart based on reference line in line chart

Anonymous — Wed, 26 Feb 2014 11:21:55 GMT

Here's a different approach which allows you to have as many color segments as you like, allows for areas changing along the x-axis, and isn't sensitive to scaling:

Watch this video which explains how to combine a line chart with stacked bars.
Create dummy data to represent your different color areas and plot this data as stacked bars. Make the bars wide, so there's no whitespace between them.
Plot your data as a line, and hey presto --- we're done!

(I can give an example qvw if someone's interested.)