topic calculate the Order Year Sequence in QlikView https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976869#M333829 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P></P><P>below is the sample data</P><P></P><P>LOAD * Inline</P><P>[</P><P>CUSTOMERID ,&nbsp; YEAR</P><P>1 , 2006</P><P>1 , 2007</P><P>2 , 2007</P><P>2 , 2012</P><P>3 , 2007</P><P>4 , 2007</P><P>5 , 2007</P><P>7 , 2005</P><P>7 , 2007</P><P>7 , 2008</P><P>7 , 2011</P><P>7 , 2013</P><P>9 , 2003</P><P>9 , 2007</P><P>9 , 2012</P><P>10 , 2007</P><P>10 , 2011</P><P>10 , 2012</P><P>11 , 2007</P><P>18 , 2006</P><P>18 , 2007</P><P>18 , 2009</P><P>18 , 2012</P><P>18 , 2013</P><P>18 , 2015</P><P>18 , 2004</P><P>18&nbsp; , 2003</P><P>]</P><P>;</P><P>looking for the Output like below.</P><P></P><P><IMG alt="CUSTOMER DETAILS.PNG" class="jive-image image-1" src="/legacyfs/online/96771_CUSTOMER DETAILS.PNG" style="height: auto;" /></P><P>each customer can make only one order per year.</P><P></P><P>CUSTOMERID = 1 make two order in 2007 and 2006.</P><P></P><P>so i need the last Sequence (YEAR)&nbsp; in the first column and next Year of Order year in the next column so on.</P><P></P><P>attached the sample file also.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Sun, 23 Aug 2015 20:45:13 GMT mdmukramali 2015-08-23T20:45:13Z calculate the Order Year Sequence https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976869#M333829 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P></P><P>below is the sample data</P><P></P><P>LOAD * Inline</P><P>[</P><P>CUSTOMERID ,&nbsp; YEAR</P><P>1 , 2006</P><P>1 , 2007</P><P>2 , 2007</P><P>2 , 2012</P><P>3 , 2007</P><P>4 , 2007</P><P>5 , 2007</P><P>7 , 2005</P><P>7 , 2007</P><P>7 , 2008</P><P>7 , 2011</P><P>7 , 2013</P><P>9 , 2003</P><P>9 , 2007</P><P>9 , 2012</P><P>10 , 2007</P><P>10 , 2011</P><P>10 , 2012</P><P>11 , 2007</P><P>18 , 2006</P><P>18 , 2007</P><P>18 , 2009</P><P>18 , 2012</P><P>18 , 2013</P><P>18 , 2015</P><P>18 , 2004</P><P>18&nbsp; , 2003</P><P>]</P><P>;</P><P>looking for the Output like below.</P><P></P><P><IMG alt="CUSTOMER DETAILS.PNG" class="jive-image image-1" src="/legacyfs/online/96771_CUSTOMER DETAILS.PNG" style="height: auto;" /></P><P>each customer can make only one order per year.</P><P></P><P>CUSTOMERID = 1 make two order in 2007 and 2006.</P><P></P><P>so i need the last Sequence (YEAR)&nbsp; in the first column and next Year of Order year in the next column so on.</P><P></P><P>attached the sample file also.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Sun, 23 Aug 2015 20:45:13 GMT https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976869#M333829 mdmukramali 2015-08-23T20:45:13Z Re: calculate the Order Year Sequence https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976870#M333830 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P></BODY></HTML> Sun, 23 Aug 2015 21:16:27 GMT https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976870#M333830 swuehl 2015-08-23T21:16:27Z Re: calculate the Order Year Sequence https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976871#M333831 <HTML><HEAD></HEAD><BODY><P>Thanks Stephen,</P><P></P><P>Perfect Solution.</P><P></P><P>Thanks,</P><P>Mukram</P></BODY></HTML> Mon, 24 Aug 2015 04:21:40 GMT https://community.qlik.com/t5/QlikView/calculate-the-Order-Year-Sequence/m-p/976871#M333831 mdmukramali 2015-08-24T04:21:40Z