Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
oliverwagner
New Contributor

4 Fiscal Quarter trailing with Dynamic Quarter start and end

Could somebody please help with the following formular:

"rangesum( above ( sum([Sales PEB At Current Year Plan Rate]),0,4) ,FQ)"

I use for 4 Fiscal Qtr trailing and it works fine, but I want to control/manage the start and end of the trailing...

so start with exclude current Qtr (= current -1) and end when less then 4Qtr remain

is this dynamic start and end for trailing doable? If so how should the formular look like?