topic Re: Last full week Qlikview in QlikView

Last full week Qlikview

robmarr789 — Wed, 25 Nov 2020 16:16:04 GMT

I am brand new to Qlikview.

I am trying to write an expression that will do the following;

SUM all sales within the last full week. This needs to roll forward in real time.

For example as of today 'last week' would include 05/03/18 - 11/03/18. The following week it will filter between 12/03/18 - 18/03/18

The fields within my source data are 'Sales' and 'DocDate'

fvelascog72 — Thu, 15 Mar 2018 15:13:44 GMT

Hi,

Try:

=Sum({<Week = {'$(=Week(Today())-1)'}>}Sales)

Where Week = Week(Date)

Saludos.

robmarr789 — Thu, 15 Mar 2018 15:31:12 GMT

Sorry I'm really amateur, could you fill in the gaps with my dates

Anonymous — Thu, 15 Mar 2018 16:02:27 GMT

hi,

If you have the Date, then try

=Sum( {< Date = {">=$(=WeekStart(today()-(1+num(WeekDay(today())))))<=$(=WeekEnd(today()-(1+num(WeekDay(today())))))"} >} Sales)

tamilarasu — Thu, 15 Mar 2018 16:22:15 GMT

Hi Robert,

Sum({<DocDate={">=$(=WeekStart(Today(), -1))<=$(=WeekEnd(Today(),-1))"}>} Sales)

zebhashmi — Thu, 15 Mar 2018 17:07:19 GMT

if(week(DocDate)=Weekstart(Today()),Sum(Sales))

and

if(week(DocDate)=Week(Today())-1,Sum(Sales))