Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
