topic Prev Contract year in QlikView https://community.qlik.com/t5/QlikView/Prev-Contract-year/m-p/518849#M193766 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P></P><P>I have attached a dummy file to explain my problem, In sheet one there is a contract with given Valid from valid to date</P><P>and in sheet 2 there is year on year variance for same contracts,</P><P>In sheet 3 i have mentioned the output desired.</P><P></P><P>i.e. every contract falls under 1 contract Year depending upon its valid from valid to date. But now user wants data of previous contract yr in the same line of current contract year.</P><P></P><P>Any help would be appreciated!!! thanks </P><P></P><P></P><P>Regards,</P><P>Rajni</P></BODY></HTML> Thu, 24 Oct 2013 10:42:26 GMT rajni_batra 2013-10-24T10:42:26Z Prev Contract year https://community.qlik.com/t5/QlikView/Prev-Contract-year/m-p/518849#M193766 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P></P><P>I have attached a dummy file to explain my problem, In sheet one there is a contract with given Valid from valid to date</P><P>and in sheet 2 there is year on year variance for same contracts,</P><P>In sheet 3 i have mentioned the output desired.</P><P></P><P>i.e. every contract falls under 1 contract Year depending upon its valid from valid to date. But now user wants data of previous contract yr in the same line of current contract year.</P><P></P><P>Any help would be appreciated!!! thanks </P><P></P><P></P><P>Regards,</P><P>Rajni</P></BODY></HTML> Thu, 24 Oct 2013 10:42:26 GMT https://community.qlik.com/t5/QlikView/Prev-Contract-year/m-p/518849#M193766 rajni_batra 2013-10-24T10:42:26Z Re: Prev Contract year https://community.qlik.com/t5/QlikView/Prev-Contract-year/m-p/518850#M193767 <HTML><HEAD></HEAD><BODY><P>See attached example</P></BODY></HTML> Thu, 24 Oct 2013 11:35:01 GMT https://community.qlik.com/t5/QlikView/Prev-Contract-year/m-p/518850#M193767 Gysbert_Wassenaar 2013-10-24T11:35:01Z