topic Fiscal ID in QlikView https://community.qlik.com/t5/QlikView/Fiscal-ID/m-p/904416#M988632 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>&nbsp;&nbsp; Am New to QlikView.Can any body pls help how to get the Month and Year from Fiscal Period ID (201406).</P><P></P><P>Regards,</P><P>K K</P></BODY></HTML> Mon, 20 Jul 2015 10:42:44 GMT Karim_Khan 2015-07-20T10:42:44Z Fiscal ID https://community.qlik.com/t5/QlikView/Fiscal-ID/m-p/904416#M988632 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>&nbsp;&nbsp; Am New to QlikView.Can any body pls help how to get the Month and Year from Fiscal Period ID (201406).</P><P></P><P>Regards,</P><P>K K</P></BODY></HTML> Mon, 20 Jul 2015 10:42:44 GMT https://community.qlik.com/t5/QlikView/Fiscal-ID/m-p/904416#M988632 Karim_Khan 2015-07-20T10:42:44Z Re: Fiscal ID https://community.qlik.com/t5/QlikView/Fiscal-ID/m-p/904417#M988633 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>LOAD <SPAN style="font-size: 13.3333330154419px;">[Fiscal Period ID],</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year(Date#([Fiscal Period ID], 'YYYYMM')) as Year,</STRONG></P><P><STRONG style="font-size: 13.3333330154419px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month(Date#([Fiscal Period ID], 'YYYYMM')) as Month</STRONG></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>FROM source</STRONG><BR /></SPAN></P></BODY></HTML> Mon, 20 Jul 2015 10:51:28 GMT https://community.qlik.com/t5/QlikView/Fiscal-ID/m-p/904417#M988633 sunny_talwar 2015-07-20T10:51:28Z