Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Previous Week using a Date time Field

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?

5 Replies
ecolomer
Master II
Master II

Try without =

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

Not applicable
Author

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

Not applicable
Author

Try

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

JonnyPoole
Former Employee
Former Employee

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

erivera10
Creator
Creator

I also saw what you saw, either.