Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Can anyone help me with a running relative time?

I need to have the 4 columns, similar to date wizard result but instead of year to date, I need  the following running time periods (dynamic running to date):

Previous 12 Months / Last 12 Months / Change / Change %.

And Previous 52 Weeks / Last 52 Weeks / Change / Change %

I've tried modifying the wizard script for 6 months into 12 but it does not work.

Thanks for you help.  Please do not attach a qvw file, my test edition does not allow to open.  Just paste the script text.

Community Browser