topic 4 Fiscal Quarter trailing with Dynamic Quarter start and end in App Development https://community.qlik.com/t5/App-Development/4-Fiscal-Quarter-trailing-with-Dynamic-Quarter-start-and-end/m-p/1461902#M36118 <HTML><HEAD></HEAD><BODY><P>Could somebody please help with the following formular:</P><P>"rangesum( above ( sum([Sales PEB At Current Year Plan Rate]),0,4) ,FQ)"</P><P>I use for 4 Fiscal Qtr trailing and it works fine, but I want to control/manage the start and end of the trailing...</P><P>so start with exclude current Qtr (= current -1) and end when less then 4Qtr remain</P><P>is this dynamic start and end for trailing doable? If so how should the formular look like?</P></BODY></HTML> Wed, 10 Jan 2018 09:08:44 GMT Anonymous 2018-01-10T09:08:44Z 4 Fiscal Quarter trailing with Dynamic Quarter start and end https://community.qlik.com/t5/App-Development/4-Fiscal-Quarter-trailing-with-Dynamic-Quarter-start-and-end/m-p/1461902#M36118 <HTML><HEAD></HEAD><BODY><P>Could somebody please help with the following formular:</P><P>"rangesum( above ( sum([Sales PEB At Current Year Plan Rate]),0,4) ,FQ)"</P><P>I use for 4 Fiscal Qtr trailing and it works fine, but I want to control/manage the start and end of the trailing...</P><P>so start with exclude current Qtr (= current -1) and end when less then 4Qtr remain</P><P>is this dynamic start and end for trailing doable? If so how should the formular look like?</P></BODY></HTML> Wed, 10 Jan 2018 09:08:44 GMT https://community.qlik.com/t5/App-Development/4-Fiscal-Quarter-trailing-with-Dynamic-Quarter-start-and-end/m-p/1461902#M36118 Anonymous 2018-01-10T09:08:44Z