Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

calculation of Moving Annual Total for different periods of time

Hi,

Just started with qv. Does anybody know how I can calculate an moving annual total for different periodes like:

- a day,

- a week,

- a month?

My problem is that some years have 365 and some other years 366 days and some years has 53 weeks and some week 52.

For example day = 22 November 2011, then I need the range of 23 November 2010 till 22 November 2011. How can I calculated this in a script?

Thanks for your help,

Ronald