Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rsapaull
Contributor III
Contributor III

Getting a line chart to stop at current month

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?

3 Replies
sunny_talwar

May be try this:

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

or

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

rsapaull
Contributor III
Contributor III
Author

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

sunny_talwar

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