topic Straight Line in Line Chart in QlikView

Straight Line in Line Chart

Thu, 10 Sep 2015 21:44:53 GMT

Hello, I have a line chart where i have amounts in yellow and blue that i want stacked. However, I need to make the third expression, which is the target, a straight line instead of stacking on top. How can I achieve this?

Thanks in advance!

-Jason

Re: Straight Line in Line Chart

Gysbert_Wassenaar — Fri, 11 Sep 2015 05:33:56 GMT

If the target line is the same value for every dimension value on the x-axis then you can use a reference line which you can add on the Presentation tab. Other wise you either have to use two charts and put them on top of each other. Or you'll have to do a lot of calculating to create expressions that result in correctly stacked areas. The combo chart doesn't support areas + line(s).

Re: Straight Line in Line Chart

Mon, 14 Sep 2015 17:47:38 GMT

Apologies for the earlier comment that I had to delete. I'm struggling to use a reference line to recreate the target. My dimension is Quarter and has values of Q1 - Q4. I tried using the following expression to create the line but it is not working: =right([Quarter],1) * 110

Re: Straight Line in Line Chart

Gysbert_Wassenaar — Tue, 15 Sep 2015 08:12:19 GMT

A reference line can have only a constant value. If you use an expression for the reference line then it can return only one value. It will be calculated at the chart level, not at the level of dimension values.

Re: Straight Line in Line Chart

Tue, 15 Sep 2015 22:28:21 GMT

Got it, thank you!

Re: Straight Line in Line Chart

Tue, 15 Sep 2015 22:28:57 GMT

Thanks Gysbert! I ended up stacking a chart on top.

-Jason