Rolling 3 Month, 6 Month, 12 Month sum

[#1]

Hello,

I need to create a table like this

                             Purchase #                Purchase $

3 Month               12                                   $2349   

6 Month               14                                   $3490

12 Month             14                                  $3490

YTD                    14                                   $3490

By default month is Current Month -1 . Can please someone help me to solve this issue? I belive I can do it on Set Analysis.

Thanks

[Gysbert_Wassenaar]

I recommend using the Qlikview Components library. See this blog post: Qlikview Notes: Easy Period Analysis using Qlikview Components. Attached an example that uses that library.

[#3]

Thanks for your reply Wassenaar. But the problem is the rolling averavge calculation should change dynamically without selecting any date or YearMonth and there is no year and month dimension.