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

Last 5 Quarters Regardless of Year Filtered

Hey Team, 
Need your help.
I would like to always see sales for the latest 5 quarters, regardless of what year that is filtered on the page.

Thanks,

Alex

 

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

 

Use something like below

Sum( {<Year=,OrderDate={">=$(=AddMonths(Max(OrderDate),-15)) <=$(=Max(OrderDate))"}>} OrderRecordCounter)