topic Re: Compare financial years in QlikView https://community.qlik.com/t5/QlikView/Compare-financial-years/m-p/465819#M1156844 <HTML><HEAD></HEAD><BODY><P>Check attached example.</P></BODY></HTML> Tue, 29 Jan 2013 15:08:42 GMT Nicole-Smith 2013-01-29T15:08:42Z Compare financial years https://community.qlik.com/t5/QlikView/Compare-financial-years/m-p/465818#M1156843 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm a QlikView newbie and have been trying to get a better idea of the best ways of being able to look at data over time when we don't use calender years but our year runs from April-March. For example I've seen an example in set analysis of comparing the year selected with the previous year. To get the current year's (Sales) data the expression used is:</P><P></P><P></P><P><SPAN style="font-size: 12pt;"><EM style="color: #808080;"><EM style="color: #808080;">Sum({$&lt;Year={$(=Only(Year))}&gt;}LineSalesAmount)</EM></EM></SPAN></P><P></P><P><SPAN style="color: #000000;"><EM style="font-size: 8pt;"><EM style="font-size: 8pt;"><SPAN id="mce_marker"><SPAN id="mce_marker"></SPAN></SPAN></EM></EM></SPAN></P><P><SPAN style="font-size: 10pt; color: #000000;">but obviously this assumes a calender year is being used.</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">I'm assuming that there is a way to get round this in the expression itself (?) but is it easier to have some sort of lookup table that assigns months to differnt years? Some advise would be really helpful as everything I've seen so far seems geared up for calender years and as I'll never be using these I'm looking for the most efficient way forward.</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">Many thanks</SPAN></P></BODY></HTML> Tue, 29 Jan 2013 08:01:19 GMT https://community.qlik.com/t5/QlikView/Compare-financial-years/m-p/465818#M1156843 2013-01-29T08:01:19Z Re: Compare financial years https://community.qlik.com/t5/QlikView/Compare-financial-years/m-p/465819#M1156844 <HTML><HEAD></HEAD><BODY><P>Check attached example.</P></BODY></HTML> Tue, 29 Jan 2013 15:08:42 GMT https://community.qlik.com/t5/QlikView/Compare-financial-years/m-p/465819#M1156844 Nicole-Smith 2013-01-29T15:08:42Z