Accumulated Line Graph

Thu, 04 Mar 2010 08:57:09 GMT

Hi All,

I need to be able to restrict an accumulated line in a chart so the line stops at the max transaction date. It was easy to set the minimum date on the another accumulated line, but i can't use the same method for a maximum date.

I have tried this:

rangesum(above(ProjectTranAmount),Sum(If(vMaxTranDate >= Date,ProjectTranAmount)))

But no luck here.

I'll try to add a picture once the image upload facility is working again.

Thanks.

Accumulated Line Graph

Tue, 09 Mar 2010 02:35:21 GMT

This is the image below:

You can see that there can be no Actual figures beyond the current date (Mar 2010) so the line continues until the maximum calendar date. I want the Actuals line to stop at Mar 2010.

topic Accumulated Line Graph in QlikView

Accumulated Line Graph

Accumulated Line Graph