Qlikview Rolling 12 Month Fiscal
Clash Royale CLAN TAG #URR8PPP Qlikview Rolling 12 Month Fiscal This forum seems to be more geared toward more programming issues but I would be interested if someone would look at the logic issue in the below link. My issue is how to calculate the previous 12 month total using the calendar already defined. I have found very few examples of this on the QV community. Please see the below link for more details. I would be willing to look at a SQL or a QV script solution. Our fiscal year runs Nov to Oct. I would like the end user to select Year and a chart to display the last rolling 12 month margin. I have had issues getting my total to accumulate for previous months. My goal would be for it look similar to the Rolling 12 Month Total - GP column in the manually caculated Excel image 'Goal'. (look at QV link for screenshot) Rolling Margin equation: my attempt to use Set Analysis to make a rolling avg equation =Sum({<master_date={'>=$(=MonthStart(Max(master_date), ...