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: 
Mch201
Contributor III
Contributor III

Most recent week function/formula?

I want to write an if statement based on data compared from the most recent week to the previous week.

 

Basically im looking for a function to say this:

If (MostRecentWeek) - (PreviousWeek) > 20, Do this, --) 

 

How would I specify the most recent week or previous week if i get new weeks data every single week?

 

Labels (4)
0 Replies