Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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...

View solution in original post