topic Re: Year over Year pace in QlikView https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426048#M459407 <HTML><HEAD></HEAD><BODY><P>Yes, but the chart does not work when I open your file.</P><P></P><P><IMG alt="Test.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178181_Test.png" style="width: 620px; height: 348px;" /></P></BODY></HTML> Fri, 29 Sep 2017 14:31:23 GMT hobanwashburne 2017-09-29T14:31:23Z Year over Year pace https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426046#M459405 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a chart similar to the following</P><P><IMG alt="Example 01.png" class="jive-image image-1" src="/legacyfs/online/177875_Example 01.png" style="height: auto;" /></P><P></P><P>where <STRONG>Daily Billing</STRONG> is the incoming for that day, <STRONG>Cumulative Current</STRONG> is the running total of the Daily Billing, and <STRONG>% LY</STRONG> is the Current Cumulative compared with last year. The cumulative of last year does not need to be shown, only the % LY.</P><P></P><P>So far no combination of RangeSum or other aggregation has been effective.&nbsp; 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.</P></BODY></HTML> Wed, 27 Sep 2017 13:02:08 GMT https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426046#M459405 hobanwashburne 2017-09-27T13:02:08Z Re: Year over Year pace https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426047#M459406 <HTML><HEAD></HEAD><BODY><P>May be like attached?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178168_Capture.PNG" style="height: 773px; width: 620px;" /></P></BODY></HTML> Fri, 29 Sep 2017 14:17:36 GMT https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426047#M459406 sunny_talwar 2017-09-29T14:17:36Z Re: Year over Year pace https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426048#M459407 <HTML><HEAD></HEAD><BODY><P>Yes, but the chart does not work when I open your file.</P><P></P><P><IMG alt="Test.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178181_Test.png" style="width: 620px; height: 348px;" /></P></BODY></HTML> Fri, 29 Sep 2017 14:31:23 GMT https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426048#M459407 hobanwashburne 2017-09-29T14:31:23Z Re: Year over Year pace https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426049#M459408 <HTML><HEAD></HEAD><BODY><P>Try now.... it seems that you are not using QV12 or above and that is by sorting within the aggr() function did not work...</P></BODY></HTML> Fri, 29 Sep 2017 14:35:48 GMT https://community.qlik.com/t5/QlikView/Year-over-Year-pace/m-p/1426049#M459408 sunny_talwar 2017-09-29T14:35:48Z