Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Start line in line on a set value, before the time axis


Hi,

I wonder if there is a way to set a starting point fo a line chart.

Lets say I have data like this

2015-01-01     104

2015-01-02     107

2015-01-03     110

2015-01-04     106

Where the first column in is a date and the second a metric.

Now if I put this into a line chart I will get the line starting at 104.

Now, is there an easy way to say that the line should start at 100 and then go to the 104-value on 2015-01-01, without having to create a 2014-12-31 fake value of 100?

It is to create an index serie and the expression is much more compley than the above so I dont really want to try to create the 100-value, so if it is possible to add it in a simple way that would be great.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Now, is there an easy way to say that the line should start at 100 and then go to the 104-value on 2015-01-01, without having to create a 2014-12-31 fake value of 100?

Nope. The easy way is to add another record in your data with the 100 value.


talk is cheap, supply exceeds demand