Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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!

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand