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: 
hobanwashburne
Creator
Creator

Year over Year pace

I'm trying to create a chart similar to the following

Example 01.png

where Daily Billing is the incoming for that day, Cumulative Current is the running total of the Daily Billing, and % LY is the Current Cumulative compared with last year. The cumulative of last year does not need to be shown, only the % LY.

So far no combination of RangeSum or other aggregation has been effective.  I have attached the sample data of three customers from 4/1/16 through 9/25/17. The fiscal year begins on 4/1 so the accumulation from last year should begin at 4/1/16 and current year should begin at 4/1/17.

1 Solution

Accepted Solutions
sunny_talwar

Try now.... it seems that you are not using QV12 or above and that is by sorting within the aggr() function did not work...

View solution in original post

3 Replies
sunny_talwar

May be like attached?

Capture.PNG

hobanwashburne
Creator
Creator
Author

Yes, but the chart does not work when I open your file.

Test.png

sunny_talwar

Try now.... it seems that you are not using QV12 or above and that is by sorting within the aggr() function did not work...