topic Re: Getting Data for Past 4 Weeks in QlikView

Getting Data for Past 4 Weeks

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

I am trying to get data for the past 4 weeks. I have tried the following but am getting the errors in expression message:

=Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(PAYMENT_POST_DATE), -4))<=$(=Date(Max(PAYMENT_POST_DATE)))’}>} REMIT_AMOUNT )

I have changed the SET DateFormat='YYYY-MM-DD' to match with PAYMENT_POST_DATE.

I found this at:

Anonymous — Wed, 21 Mar 2018 22:51:42 GMT

I also tried the following but got the same errors in expression::

=Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Today(), -14))<=$(=Today())’}>} Sales )

What should the format of the Today() be? I currently have it as SET DateFormat='YYYY-MM-DD';

Anonymous — Wed, 21 Mar 2018 23:01:17 GMT

I have a chart that needs to look back 10 weeks.

I get no data display for the following:

=Sum({=$(=WeekStart(Max(Date), -10))<=$(=WeekEnd(Max(Date)))'}>} Value)

Last 15 Weeks Sales
Sum({=$(=WeekStart(Max(Date), -10))<=$(=Date(Max(Date)))’}>} Sales )

Sum({=$(=WeekStart(Today(), -10))<=$(=Today())’}>} Sales )

Anonymous — Thu, 22 Mar 2018 00:00:42 GMT

I got it to work with the following code:

=Sum({<PAYMENT_POST_DATE={">=$(=Weekstart(Max(PAYMENT_POST_DATE), -9))<=$(=Date(Max(PAYMENT_POST_DATE)))"}>} REMIT_AMOUNT)