topic Re: Line Chart / Mountain Chart Combo in QlikView

Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 05:07:26 GMT

I need to create a line chart that has 2 measures, open and close issues. I need to color/shade the area between the measures. Is this chart possible to create in QV ? I am looking at using a mountain chart but I'm not able to achieve the desired color results as attached.

Any idea ?

Re: Line Chart / Mountain Chart Combo

sbaldwin — Wed, 28 Sep 2011 13:00:30 GMT

you should be able to change the chart type to filled lines in the stype tab then it is just a matter of changing the fill of the lower line to white, see attached example

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 14:03:56 GMT

Hi,

i don't know the complexity of your expression, but maybe this could be ok for you.

C u,

Stefano.

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 14:14:45 GMT

Thank you for the response. If you notice in the example, there is a red line (open issues) and a green line (close issues). I'm able to accomplish the area shading between the lines by changing the first expression's background color to white, however, all is left is the red area (open issues). I no longer get the green line since i changed the bg color to white. The requirement is a red line, a green line and a different color to shade the area between the lines.

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 14:17:02 GMT

Hi Stefano, Thank you for responding. Your example is the same as mine. I just can't get the look and feel of what is needed - a green line, a red line and the area shading between lines. I guess it is not at all possible then.

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 14:45:43 GMT

I suppose that u don't want to use an other graph overlapped..

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 14:49:02 GMT

You read my mind. Yes, i don't want to use a chart overlay. so it seems that it cannot be done using the regular line chart.

Re: Line Chart / Mountain Chart Combo

sicilianif — Wed, 28 Sep 2011 19:20:12 GMT

You could add an expression prior to the one you want to be a line and make the color white for it. Now instead of 2 expressions, you would have 3. The value for the first expression would be what you originally had in the in the first expression minus some number. The number will depend on how thick you want the line to show. The second expression would now just be the number that you subtracted in the first expresion. The third expression would be what you originally had in your second expression.

Hopefully that make sense.

This would work for display purposes, and you would probably want to turn off pop-ups because the numbers would be wrong because of the new expression.

If I could figure out how to upload, I would attach an example.

Frank

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 21:06:49 GMT

Hi,

I don't know if this is what u are saying, but i think it works quite fine.

I need 4 expression.

C u,

Stefano.

Re: Line Chart / Mountain Chart Combo

sicilianif — Wed, 28 Sep 2011 23:36:02 GMT

Yes. To get two distinct color lines with a different color band in the middle, you would need 4 expressions.

Frank

Re: Line Chart / Mountain Chart Combo

Wed, 28 Sep 2011 23:50:14 GMT

Great stuff Guys ! Thanks for sharing.

Re: Line Chart / Mountain Chart Combo

Tue, 28 Jan 2014 10:52:25 GMT

Could you please explain in more detail how to use/define the 4 expressions? Because I am not able to open your attached file. Please specify how to colour the area between two curves.

Any help will be appreciated.

Re: Line Chart / Mountain Chart Combo

sicilianif — Tue, 28 Jan 2014 13:50:39 GMT

Expression 1 (creates white space at the bottom) - The expression would be the value for the fist line -1. You would make the color white.

Expression 2 (first line) - This is your line expression.

Expression 3 (creates color between) - This would be the second line value -1.

Expression 4 (second line) - This is your second line expression.