topic Re: Line chart drawing line beyond last data point in QlikView

Line chart drawing line beyond last data point

cgaleaQlik — Sat, 16 Nov 2024 00:24:04 GMT

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.

Appreciate any help you can provide. 😊

Charles

Re: Line chart drawing line beyond last data point

rubenmarin — Tue, 30 Jun 2020 15:47:17 GMT

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())))

Re: Line chart drawing line beyond last data point

cgaleaQlik — Wed, 01 Jul 2020 02:06:25 GMT

Thanks Rubenmarin, it works perfectly.

Greatly appreciated!!!

Charles