https://community.qlik.com/t5/App-Development/Most-recent-week-function-formula/m-p/1779371#M60578 <P>I want to write an if statement based on data compared from the most recent week to the previous week.</P><P>&nbsp;</P><P>Basically im looking for a function to say this:</P><P>If (MostRecentWeek) - (PreviousWeek) &gt; 20, Do this, --)&nbsp;</P><P>&nbsp;</P><P>How would I specify the most recent week or previous week if i get new weeks data every single week?</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:32:15 GMT Mch201 2024-11-16T17:32:15Z https://community.qlik.com/t5/App-Development/Most-recent-week-function-formula/m-p/1779371#M60578 <P>I want to write an if statement based on data compared from the most recent week to the previous week.</P><P>&nbsp;</P><P>Basically im looking for a function to say this:</P><P>If (MostRecentWeek) - (PreviousWeek) &gt; 20, Do this, --)&nbsp;</P><P>&nbsp;</P><P>How would I specify the most recent week or previous week if i get new weeks data every single week?</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:32:15 GMT https://community.qlik.com/t5/App-Development/Most-recent-week-function-formula/m-p/1779371#M60578 Mch201 2024-11-16T17:32:15Z