topic Dynamic Fiscal Year in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Fiscal-Year/m-p/294652#M109304 <HTML><HEAD></HEAD><BODY><P> Hi I have a graph which has month and year on the x axes, the y expression is a rolling 12 mths sales . For example&nbsp; Dec 11 will show sales for Dec 10 - Dec 11.</P><P></P><P>I then want to divide into this figure the full sales for the previous fin year (Apr 10 - Mar 11) how can i make this dynamic. For example Dec 10 rolling sales covering the period Dec 09 - Dec 10 should be divided by Apr 09 - Mar 10 - how do I make the fiscal year dynamic based on the x axes dimension ? </P><P></P><P>Many thanks for your help. </P><P></P><P>Darrell.</P></BODY></HTML> Mon, 12 Dec 2011 22:00:59 GMT darrellbutler 2011-12-12T22:00:59Z Dynamic Fiscal Year https://community.qlik.com/t5/QlikView/Dynamic-Fiscal-Year/m-p/294652#M109304 <HTML><HEAD></HEAD><BODY><P> Hi I have a graph which has month and year on the x axes, the y expression is a rolling 12 mths sales . For example&nbsp; Dec 11 will show sales for Dec 10 - Dec 11.</P><P></P><P>I then want to divide into this figure the full sales for the previous fin year (Apr 10 - Mar 11) how can i make this dynamic. For example Dec 10 rolling sales covering the period Dec 09 - Dec 10 should be divided by Apr 09 - Mar 10 - how do I make the fiscal year dynamic based on the x axes dimension ? </P><P></P><P>Many thanks for your help. </P><P></P><P>Darrell.</P></BODY></HTML> Mon, 12 Dec 2011 22:00:59 GMT https://community.qlik.com/t5/QlikView/Dynamic-Fiscal-Year/m-p/294652#M109304 darrellbutler 2011-12-12T22:00:59Z