topic Re: Calculate last week in QlikView

Calculate last week

Anonymous — Tue, 11 Feb 2014 12:38:05 GMT

Hi,

there is a short mistake in my formular? Actual week should be calculated new, so i get last week: This Week - 1

Variable: varActualWeekNum = Week(Today())

=sum( {<LastWeekNum = {$(varActualWeekNum-1})>} ANZ_INT_ID_GR)

Regards
Stefan

luis_pimentel — Tue, 11 Feb 2014 12:41:52 GMT

Try:

=sum( {<LastWeekNum = {$(varActualWeekNum)-1}>} ANZ_INT_ID_GR)

=sum( {<LastWeekNum = {$($(varActualWeekNum)-1)}>} ANZ_INT_ID_GR)

Anonymous — Tue, 11 Feb 2014 12:51:36 GMT

Hi,

thanks for your reply. Last delivery It doesn't work?

MK_QSL — Tue, 11 Feb 2014 13:01:10 GMT

Try this...

=SUM({<LastWeekNum = {'$(=varActualWeekNum-1)'}>}ANZ_INT_ID_GR)