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: 
Not applicable

How to displaying Year-to-date chart line based on monthly data

I am attempting to build chart with a line for each year where the lines represents the accumulated YTD revenue for each month. (The resulting lines generally increases each month as the new month's revenue is included)
The input needs to be the 'SUM(Revenue)' for each =DATE(Date, 'MMM YY') across multiple years. If this is possible please provide the expression to be used in the chart expressions.

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Is the attached what you're looking for?

View solution in original post

2 Replies
johnw
Champion III
Champion III

Is the attached what you're looking for?

Not applicable
Author

Exactly, thanks. I guess that is what happens when you try to make something complex out of something simple anf/or fail to RTFM enough. So simply checking full accum on the Expressions Tab is all that is required, Embarrassed Thanks again.