Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Georgy_Paul
Contributor II
Contributor II

Rolling two month Average

Hi. I want to create a stacked bar chart with rolling two month average. The dimensions are Product and Month , Measure being Sales. But for some months there is no data available for certain country (Country is a filter ). So if the Data for June is missing, then the rolling avg should take the data of July and May to calculate July Average. Similarly if the data for two months are missing, it should take the data of last available month. Is there any method to implement this dynamically ?

Labels (1)
0 Replies