Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sebHan
Contributor III
Contributor III

Extension of timeline with last data point.

Hey!

I'm currently working on a timeline, where  I want the timeline to continue with the last data point.

Currently the timeline looks like this:

sebHan_0-1638369137709.png

Basically I just want it to be a straigthline after October 2021 with 100.346 on every data point.

Is there a way to do this?

 

Labels (1)
1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

You can use If statement in your expression for the Measure. For example I have the following Line Chart:

SCREENSHOT

The Expression that I used is: Sum(Value)

 

Now if I use the following expression:

if(Sum(Value)=0, 100346, Sum(Value))

 

I get the output:

SCREENHSOT

 

This tells the Chart Line to use the value 100346 where the sum of the value is 0 (which are the points after October 2021)

 

Is this the information that you were looking for? If it has helped you resolve the issue, please accept it as solution, to give more visibility to other community members. Otherwise, if I have misunderstood the use case scenario, please elaborate in detail, by providing additional information.

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

1 Reply
Andrei_Cusnir
Specialist
Specialist

Hello,

 

You can use If statement in your expression for the Measure. For example I have the following Line Chart:

SCREENSHOT

The Expression that I used is: Sum(Value)

 

Now if I use the following expression:

if(Sum(Value)=0, 100346, Sum(Value))

 

I get the output:

SCREENHSOT

 

This tells the Chart Line to use the value 100346 where the sum of the value is 0 (which are the points after October 2021)

 

Is this the information that you were looking for? If it has helped you resolve the issue, please accept it as solution, to give more visibility to other community members. Otherwise, if I have misunderstood the use case scenario, please elaborate in detail, by providing additional information.

Help users find answers! Don't forget to mark a solution that worked for you! 🙂