Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Vimarsh
Contributor II
Contributor II

Bar Chart for Rolling12 values

I have a monthly dataset for different years (say 2017 and 2018) and I am trying t create a chart which would show the Rolling12 number at each month of 2018.

MonthYearAmount
Jan2017400
Feb2017200
Mar2017300
Apr2017100
May2017500
Jun2017200
Jul2017500
Aug2017300
Sep2017300
Oct2017400
Nov2017100
Dec2017100
Jan2018500
Feb2018200
Mar2018200
Apr2018400
May2018400
Jun2018300
Jul2018100
Aug2018500
Sep2018500
Oct2018200
Nov2018100
Dec2018100

 

I want to create a graph for just 2018 months and show sum of amount for last 12 months against each month. How can I achieve this?

Something like below

Img3.JPG

Appreciate any help here!

Thank You!

0 Replies