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,

    Martin

     

    PS: Unbroken weeks have been used in example.