Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calendar / LQA / Rolling Quarter

Working for a growing company, one of the metrics that we want to track is LQA, a.k.a. Last Quarter Annualized.   I'm not even sure where I need to start to be able to build this option into a calendar to make it as a list box item. I've searched on here an cannot find anything on this term.

Essentially there are two different ways to view LQA.  It can be considered a rolling 3 month period, which is then multiplied by 4 (3x4 = 12), or it can be any fiscal quarter multiplied by 4. 


Any help is appreciated!

1 Reply
Gysbert_Wassenaar

Perhaps this document gives you ideas: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand