topic Re: Calendar / LQA / Rolling Quarter in QlikView https://community.qlik.com/t5/QlikView/Calendar-LQA-Rolling-Quarter/m-p/821499#M1037109 <HTML><HEAD></HEAD><BODY><P>Perhaps this document gives you ideas: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Wed, 21 Jan 2015 13:56:44 GMT Gysbert_Wassenaar 2015-01-21T13:56:44Z Calendar / LQA / Rolling Quarter https://community.qlik.com/t5/QlikView/Calendar-LQA-Rolling-Quarter/m-p/821498#M1037108 <HTML><HEAD></HEAD><BODY><P>Working for a growing company, one of the metrics that we want to track is LQA, a.k.a. Last Quarter Annualized.&nbsp;&nbsp; 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. </P><P></P><P>Essentially there are two different ways to view LQA.&nbsp; 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.&nbsp; </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Any help is appreciated! </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Tue, 20 Jan 2015 14:08:46 GMT https://community.qlik.com/t5/QlikView/Calendar-LQA-Rolling-Quarter/m-p/821498#M1037108 Anonymous 2015-01-20T14:08:46Z Re: Calendar / LQA / Rolling Quarter https://community.qlik.com/t5/QlikView/Calendar-LQA-Rolling-Quarter/m-p/821499#M1037109 <HTML><HEAD></HEAD><BODY><P>Perhaps this document gives you ideas: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Wed, 21 Jan 2015 13:56:44 GMT https://community.qlik.com/t5/QlikView/Calendar-LQA-Rolling-Quarter/m-p/821499#M1037109 Gysbert_Wassenaar 2015-01-21T13:56:44Z