topic Re: Financial periods in QlikView https://community.qlik.com/t5/QlikView/Financial-periods/m-p/1057387#M354300 <HTML><HEAD></HEAD><BODY><P>Can you try one of these:</P><P></P><P><STRONG>Max(DISTINCT CDate, -13)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>AddYears(Max(CDate), -1)</STRONG></P></BODY></HTML> Tue, 05 Apr 2016 12:48:59 GMT sunny_talwar 2016-04-05T12:48:59Z Financial periods https://community.qlik.com/t5/QlikView/Financial-periods/m-p/1057386#M354299 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need financial periods. I created following variables. comparing Previous FY count Vs Current FY count.</P><P><SPAN style="color: blue; font-family: 'Courier New'; font-size: 9pt;">max</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">CDate,-13</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">)</SPAN> and <SPAN style="color: blue; font-family: 'Courier New'; font-size: 9pt;">max</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">CDate,-12</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">) retunes&nbsp; <SPAN style="font-family: Courier New;">02/29/2016</SPAN>. <SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">I need 02/28/2015.</SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: blue; font-family: 'Courier New'; font-size: 9pt;">max</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">CDate</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">) = 02/29/2016</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: blue; font-family: 'Courier New'; font-size: 9pt;">min</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">CDate</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">)=04/01/2014</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: blue; font-family: 'Courier New'; font-size: 9pt;">min</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">CDate,13</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">)=04/01/2015</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: blue; font-family: 'Courier New'; font-size: 9pt;">max</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">CDate,-13</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">) =02/29/2016</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> Thanks,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Krishna</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Tue, 05 Apr 2016 12:45:53 GMT https://community.qlik.com/t5/QlikView/Financial-periods/m-p/1057386#M354299 Anonymous 2016-04-05T12:45:53Z Re: Financial periods https://community.qlik.com/t5/QlikView/Financial-periods/m-p/1057387#M354300 <HTML><HEAD></HEAD><BODY><P>Can you try one of these:</P><P></P><P><STRONG>Max(DISTINCT CDate, -13)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>AddYears(Max(CDate), -1)</STRONG></P></BODY></HTML> Tue, 05 Apr 2016 12:48:59 GMT https://community.qlik.com/t5/QlikView/Financial-periods/m-p/1057387#M354300 sunny_talwar 2016-04-05T12:48:59Z