Rolling 52 weeks

helen_pip — Thu, 25 Apr 2013 14:21:01 GMT

Hello

I have trawled the internet for something to help me calculate the last rolling 52 weeks

My data will always show the current and last financial year I.e. Apr 2012 to Current date onwards

I have an expression called variance which is calculating last financial years postion against current FY position

My load script will update monthly and what I want to show in my variance calculation is variance for the last rolling 52 weeks, are you able to help achieve this?

My expression is:

num((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)-Count({<YEAR = {$(=Max(YEAR)-1)}>}LOCAL_PATIENT_IDENTIFIER)*100,'%')

In the script I also have written a week: Date(Weekstart([REFERRAL_DATE]), 'DD-MM-YYYY') AS OutPatients_Week

I just do not know where to start, can anyone help me achieve this please, or set me on my way

Kind Regards

Helen

Re: Rolling 52 weeks

shree909 — Thu, 25 Apr 2013 21:30:40 GMT

try this

num((Count({<YEAR = { ">=$(=Max(YEAR)-1) <=$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER))*100,'%')

num((Count({<YEAR = { ">=$(=Max(YEAR)-1) <=$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER))'#,##0%')

by using the above expression You are taking the dates between current and previous year and calulting the count.

topic Rolling 52 weeks in QlikView

Rolling 52 weeks

Re: Rolling 52 weeks