topic Re: How can i substract Year field from Current Year? in QlikView https://community.qlik.com/t5/QlikView/How-can-i-substract-Year-field-from-Current-Year/m-p/442235#M164860 <HTML><HEAD></HEAD><BODY><P>use this:</P><P></P><P>Load Year, year(today())-Year as NewYearfield</P></BODY></HTML> Mon, 17 Dec 2012 11:52:28 GMT 2012-12-17T11:52:28Z How can i substract Year field from Current Year? https://community.qlik.com/t5/QlikView/How-can-i-substract-Year-field-from-Current-Year/m-p/442234#M164859 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a field Year.</P><P></P><P>Year:</P><P>2005</P><P>2006</P><P>2007</P><P></P><P>How can i create another field by substracting each value of Year Field from the Current Year.</P><P></P><P>How i need is </P><P></P><P>2012-2005</P><P>2012-2006</P><P>2012-2007</P><P>in a seperate field.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards</P><P>Kumar</P></BODY></HTML> Mon, 17 Dec 2012 11:44:15 GMT https://community.qlik.com/t5/QlikView/How-can-i-substract-Year-field-from-Current-Year/m-p/442234#M164859 2012-12-17T11:44:15Z Re: How can i substract Year field from Current Year? https://community.qlik.com/t5/QlikView/How-can-i-substract-Year-field-from-Current-Year/m-p/442235#M164860 <HTML><HEAD></HEAD><BODY><P>use this:</P><P></P><P>Load Year, year(today())-Year as NewYearfield</P></BODY></HTML> Mon, 17 Dec 2012 11:52:28 GMT https://community.qlik.com/t5/QlikView/How-can-i-substract-Year-field-from-Current-Year/m-p/442235#M164860 2012-12-17T11:52:28Z