Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling of 3 month in Qlik sense

Hi,

I am facing problem in rollling of 3 month data with aggr() function and passing 2 dimensions of dim1 and dim2,

my input filters are fiscalyear like 2016-17, & fiscal month like Apr,May,Jun.. to Mar

please let me know how to achieve this scenario.

Regards, Arun

4 Replies
sunny_talwar

Would you be able to share more details and ideally a sample with expected output to understand your issue better

fkeuroglian
Partner - Master
Partner - Master

Hi Arun

See this explanation, was a good one

is in qlikview but have the same logic

Calculating rolling n-period totals, averages or other aggregations

https://community.qlik.com/docs/DOC-8574

Fernando K.

Not applicable
Author

Thank you fernando..:)

Not applicable
Author

got idea with below suggestion.. thanks for your reply..