Rolling Weeks/Months/Quarters

    Hi guys,


    I would like to share with you small example how to deal with rolling periods. Many of you may face situations when somebody ask to provide visualization for last (next) n-weeks, n-months or n-quarters.


    Purpose of this small .qvw is to show how to create sequence of numbers for particular periods and operate with it using set analysis.


    Example uses @Actual{period} value, but of course you can freely use other aproach (=max(ID{period})).


    Wish you all the best.

    Enjoy day.


    Best regards,



    PS: Unbroken weeks have been used in example.