topic Re: Draw a line on a chart with two coordinates in QlikView

Draw a line on a chart with two coordinates

Maarten — Mon, 20 Dec 2021 13:37:14 GMT

Hi,

I have a simple chart that represents the sum of amounts for a given day. Easy.

Now I want to draw (in another expression) an extra line (see red line in pictures) that always goes from

Coordinate 1: [smallest displayed date in the chart (i.e. 01/01/2021), Corresponding Y-value)
Coordinate 2: [largest displayed date in the chart (i.e. 01/05/2021), fixed '0.1' value).

regardless the selection made. Is that possible? How?

Thank you very much.

Maarten

Re: Draw a line on a chart with two coordinates

Andrei_Cusnir — Tue, 21 Dec 2021 11:00:51 GMT

Hello,

The easiest and fastest way to achieve this is following the answer provided in this post [1]. This answer states that you can use the Line\Arrow object with the background color set to Transparent. Then you will have the following outcome:

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.

---

[1] https://community.qlik.com/t5/QlikView-App-Dev/Draw-straight-line/td-p/717711

Re: Draw a line on a chart with two coordinates

Maarten — Mon, 10 Jan 2022 13:01:10 GMT

Hi,

Sorry for not replying earlier; I've been taking a break during the winter holidays and missed out this post.

Actually, the line solution would be OK if the data was always the same...

Maybe I confused you with the last sentence "regardless the selection made." (so let's forget about that one).

Basically I would need to make a forecast line, for which the line keeps on going in the future until it meets the 0 point of the y-axis (even if there was no dimension data present in the original dataset). Think of a burn down chart where you want mark the spot where all work should be done. I want to know and display that moment on the chart.

Hope that helps,

Maarten

Re: Draw a line on a chart with two coordinates

Harvey — Sat, 29 Jan 2022 04:14:32 GMT

You will use a line chart when you want to emphasize changes in values for one variable (plotted on the vertical axis) for continuous values of a second variable (plotted on the horizontal). ePayitonline This emphasis on patterns of change is sold by line segments moving consistently from left to right and observing the slopes of the lines moving up or down.