Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Maarten
Partner - Contributor II
Partner - Contributor II

Draw a line on a chart with two coordinates

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?

Goal.jpg

Thank you very much.

Maarten

 

3 Replies
Andrei_Cusnir
Specialist
Specialist

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: 

 

SCREENSHOT

 

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

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
Maarten
Partner - Contributor II
Partner - Contributor II
Author

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

Harvey
Contributor
Contributor

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.