Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Line chart drawing line beyond last data point

Hi All,

I am try to create a line chart with two lines. One is based on the equation Sum(Values) from Apr 2017 to Dec 2018. While the other is Sum(Value * 0.9) from Apr 2017 to Dec 2017. However, the plot is drawing a line past the last data point (Dec 2017) for the second line (circled in red in the screenshot). I've attached a file illustrating my problem.

Screenshot of line chart showing line plotted after last data point for green line.Screenshot of line chart showing line plotted after last data point for green line.

Appreciate any help you can provide. 😊

Charles 

Labels (2)
1 Solution

Accepted Solutions
Highlighted

Re: Line chart drawing line beyond last data point

Hi, if this can help you, I achieve to stop line expansion doing the accumulation on the expression:

if(Date>='01/01/2018', null(), rangesum(Above(sum(if(Date<'01/01/2018',Value,Null())), 0 ,RowNo())))

 

View solution in original post

Tags (1)
2 Replies
Highlighted

Re: Line chart drawing line beyond last data point

Hi, if this can help you, I achieve to stop line expansion doing the accumulation on the expression:

if(Date>='01/01/2018', null(), rangesum(Above(sum(if(Date<'01/01/2018',Value,Null())), 0 ,RowNo())))

 

View solution in original post

Tags (1)
Highlighted
Contributor
Contributor

Re: Line chart drawing line beyond last data point

Thanks Rubenmarin, it works perfectly.

Greatly appreciated!!!

Charles