topic Re: Set Analysis - Previous Week using a Date time Field in QlikView

Set Analysis - Previous Week using a Date time Field

Tue, 19 Aug 2014 13:01:02 GMT

I'm struggling to write an expression in a line graph to show the previous week's information. I'd also like a Year to Date average to show as a separate line.

Count({$<(=Week(DateCreated))={$((=Week(DateCreated))-1)>},if(type = 'SHIPMENT',type))

Can someone explain where I am going wrong and the reason for it not working?

Re: Set Analysis - Previous Week using a Date time Field

ecolomer — Tue, 19 Aug 2014 13:14:38 GMT

Try without =

Count({$<(Week(DateCreated))={$((=Week(DateCreated))-1)>},if(type = 'SHIPMENT',type))

Re: Set Analysis - Previous Week using a Date time Field

Tue, 19 Aug 2014 13:17:12 GMT

Doesn't make a difference unfortunately - it appears to just be plotting the current week selection and not the week-1

Re: Set Analysis - Previous Week using a Date time Field

Tue, 19 Aug 2014 13:30:00 GMT

Try

Count({$<(Week(DateCreated))={$((=Week(DateCreated)-1))>},if(type = 'SHIPMENT',type))

Re: Set Analysis - Previous Week using a Date time Field

JonnyPoole — Tue, 19 Aug 2014 13:35:42 GMT

Check out this explanatory post on grabbing prior periods.

the above() function may help you grab previous week data in a chart.

Calculating rolling n-period totals, averages or other aggregations

Re: Set Analysis - Previous Week using a Date time Field

erivera10 — Tue, 19 Aug 2014 14:16:29 GMT

I also saw what you saw, either.