topic Re: Set Analysis - show previous weeks in QlikView

Set Analysis - show previous weeks

Wed, 29 Jul 2015 18:51:55 GMT

Hello,

I'm putting together a report where I need to select a week or dayand be able to compare this to the previous 4 weeks before that.

How can I do this and can I see that in the same graphic?

Thanks!

MK_QSL — Wed, 29 Jul 2015 20:29:54 GMT

Current Week

Sum({<Date = {">=$(=Date(WeekStart(Today())))<=$(=Date(WeekEnd(Today())))"}>}Sales)

Last Week

Sum({<Date = {">=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekEnd(Today())-7))"}>}Sales)

For 4 Week adjust accordingly...