topic Re: Fiscal year - 4years in QlikView https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126836#M370845 <HTML><HEAD></HEAD><BODY><P>How does the FISCAL_YEAR field look like? Does it contain straight numbers?</P></BODY></HTML> Wed, 11 May 2016 17:46:40 GMT sunny_talwar 2016-05-11T17:46:40Z Fiscal year - 4years https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126835#M370844 <HTML><HEAD></HEAD><BODY><P>I have a column in my load statment as below:</P><P>FISCAL_YEAR </P><P></P><P></P><P>how do i load the data to last 4 years here ?</P><P>there is no query.It loads from a system generated csv file. So i want to restrict on load sttamenet</P></BODY></HTML> Wed, 11 May 2016 17:42:06 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126835#M370844 rdsuperlike 2016-05-11T17:42:06Z Re: Fiscal year - 4years https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126836#M370845 <HTML><HEAD></HEAD><BODY><P>How does the FISCAL_YEAR field look like? Does it contain straight numbers?</P></BODY></HTML> Wed, 11 May 2016 17:46:40 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126836#M370845 sunny_talwar 2016-05-11T17:46:40Z Re: Fiscal year - 4years https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126837#M370846 <HTML><HEAD></HEAD><BODY><P>you can also apply a where condition to a csv file </P><P></P><P>so if the fiscal year has a format of YYYY then you could do </P><P></P><P>load</P><P>*</P><P>from .....</P><P>where <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FISCAL_YEAR </SPAN>&gt;= 2012</P></BODY></HTML> Wed, 11 May 2016 17:49:36 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-4years/m-p/1126837#M370846 ramoncova06 2016-05-11T17:49:36Z