topic Re: Fiscal Year and Fiscal Month in QlikView https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135192#M601710 <HTML><HEAD></HEAD><BODY><P>Thyankyou is working fine now. </P></BODY></HTML> Fri, 02 Nov 2018 08:54:12 GMT prabunakil 2018-11-02T08:54:12Z Fiscal Year and Fiscal Month https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135189#M601707 <HTML><HEAD></HEAD><BODY><P>my script is to load </P><P></P><P>Left (FKDAT,2) as TransDay,</P><P><SPAN style="font-size: 13.3333px;">Mid (FKDAT,4,2) as TransMonth,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Right (FKDAT,4) as TransYear,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">But the issue is my physical year start with April. </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">How to load to make it correctly. <BR /></SPAN></P></BODY></HTML> Thu, 25 Oct 2018 01:21:39 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135189#M601707 prabunakil 2018-10-25T01:21:39Z Re: Fiscal Year and Fiscal Month https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135190#M601708 <HTML><HEAD></HEAD><BODY><P>I am assuming you looking for below,</P><P></P><P>YearName (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">FKDAT</SPAN>,0,4)</P><P></P><P>I am not sure why you are using mid, left and right function instead of the standard calendar function ?</P></BODY></HTML> Thu, 25 Oct 2018 02:00:43 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135190#M601708 maheshkuttappa 2018-10-25T02:00:43Z Re: Fiscal Year and Fiscal Month https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135191#M601709 <HTML><HEAD></HEAD><BODY><P>You need&nbsp; to add a condtion Like </P><P></P><P></P><P>If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">TransMonth</SPAN>= Match(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">TransMonth</SPAN>,'Jan','Feb','Mar'),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">TransYear-1,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">TransYear )</SPAN></SPAN>as Date,</P></BODY></HTML> Thu, 25 Oct 2018 04:56:12 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135191#M601709 techvarun 2018-10-25T04:56:12Z Re: Fiscal Year and Fiscal Month https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135192#M601710 <HTML><HEAD></HEAD><BODY><P>Thyankyou is working fine now. </P></BODY></HTML> Fri, 02 Nov 2018 08:54:12 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year-and-Fiscal-Month/m-p/135192#M601710 prabunakil 2018-11-02T08:54:12Z