Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hobanwashburne
Contributor

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
MVP
MVP

Re: Year over Year pace

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

3 Replies
MVP
MVP

Re: Year over Year pace

May be like attached?

Capture.PNG

hobanwashburne
Contributor

Re: Year over Year pace

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

Test.png

MVP
MVP

Re: Year over Year pace

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

Community Browser