Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Weekly Data

 

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 )

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

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...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.