Set analysis - weeks back ?

Thu, 28 Nov 2013 14:18:19 GMT

Hi there,

I have a column in my document for the sum of the val in the past 7 days which is below:

=Sum({< dated = {'>=$(=Date(V_todayminus7days13weekroller))<=$(=Date(V_today13weekroller))'} >} val)

The variables are currently:

V_today13weekroller- =today()

V_todayminus7days13weekroller- =today() - 7

Now I need to sum the val where the date is within the last 13 weeks (replicating the SQL command ‘datediff(ww,dated,getdate()) <=13’). Does anyone know how to get the date for the start of the week 13 weeks ago ? Or can think of a better way of doing this ??

Many Thanks

Tom

Re: Set analysis - weeks back ?

swuehl — Thu, 28 Nov 2013 14:26:15 GMT

Something like

weekstart(today() - 91)

should do for a Monday weekstart.

topic Re: Set analysis - weeks back ? in QlikView

Set analysis - weeks back ?

Re: Set analysis - weeks back ?