Weekly Data

[danieldors]

Hello,

The expression below pulls the most recent week, which includes the current, Im looking to pull the most recent full week, how would I update the  expression below to return last weeks count. Thank you.

=Count( {$<EndDateCal = {">=$(=Weekstart(max([Created_On.autoCalendar.Date],1)))<=$(=Weekend(max([Created_On.autoCalendar.Date],1)))"} >} Referral_Number )

[vinieme12]

to check previous week simply change the period to -1

=Count( {$<EndDateCal = {">=$(=Weekstart(max([Created_On.autoCalendar.Date],-1)))<=$(=Weekend(max([Created_On.autoCalendar.Date],-1)))"} >} Referral_Number )

read more here

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...