topic Getting a line chart to stop at current month in QlikView

Getting a line chart to stop at current month

rsapaull — Wed, 29 Jun 2016 11:26:47 GMT

I've got a plan vs actual graph on one of my dashboards and I'd like to get the actual line to stop at the current month. The line currently has a formula as follows:

rangesum(Above(Sum ([Code End Month Count]),0,rowno()))

Can anyone help in the code or settings with a way to stop the line please?

Re: Getting a line chart to stop at current month

sunny_talwar — Wed, 29 Jun 2016 16:28:07 GMT

May be try this:

If(Sum([Code End Month Count]) > 0, Rangesum(Above(Sum ([Code End Month Count]), 0, RowNo())))

If(Len(Trim(Avg([Code End Month Count]))) > 0, Rangesum(Above(Sum ([Code End Month Count]), 0, RowNo())))

Re: Getting a line chart to stop at current month

rsapaull — Thu, 30 Jun 2016 08:30:59 GMT

Unfortunately this won't work as there is the odd item which gets done ahead of schedule.

Re: Getting a line chart to stop at current month

sunny_talwar — Thu, 30 Jun 2016 11:25:45 GMT

Would you be able to share a sample showing your issue?