Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
KumaRan
New Contributor III

Moving Annual Total

Hi all,

I have to find Moving annual total. Its not like Rolling 12 months display.

 X axis has to display last 12 months. But each month(Bar) should show total of  previous 12 months from that particular month

 For example if current month is Nov 2018

 X Axis

Oct 18      -  Sep 18+ Aug 18+ Jul 18+ Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17

Sep 18      - Aug 18+ Jul 18+ Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17

Aug 18      - Jul 18+ Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17 +Aug 17

Jul 18        - Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17

Jun 18       - May 18+ Apr 18+ Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17

May 18     - Apr 18+ Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17 +May 17

Apr 18      - Mar 18 +Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17 +Apr 17

Mar 18      - Feb 18+ Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17

Feb 18      - Jan  18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17

Jan  18     - Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17+ Jan 17

Dec 17     - Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17+ Jan 17 + Dec 16

Nov 17    - Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17+ Jan 17+ Dec 16 + Nov 16

 

Can you suggest me is it possible? If so can you suggest me solution?

Thanks in anticipation.

Labels (1)
2 Replies
MVP
MVP

Re: Moving Annual Total

This is very much possible. May times similar issues have been discussed. Try searching community: https://community.qlik.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&f...

KumaRan
New Contributor III

Re: Moving Annual Total

Hi Tresesco,

This what i am looking for. Thanks for your suggestion