topic Re: Inter record counting in QlikView https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961223#M648092 <HTML><HEAD></HEAD><BODY><P>Brilliant, thank you!! </P></BODY></HTML> Wed, 16 Sep 2015 12:18:02 GMT 2015-09-16T12:18:02Z Inter record counting https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961221#M648090 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>A simplified example of the data which I'm loading into my model looks something like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">OrderID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">OrderDate</TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;"><P>10001</P></TD><TD style="padding: 2px;">2015-01-01</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">10002</TD><TD style="padding: 2px;">2015-01-01</TD></TR><TR><TD style="padding: 2px;">Jane</TD><TD style="padding: 2px;">10003</TD><TD style="padding: 2px;">2015-01-01</TD></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">10004</TD><TD style="padding: 2px;">2015-01-02</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">10005</TD><TD style="padding: 2px;">2015-01-03</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">10006</TD><TD style="padding: 2px;">2015-01-03</TD></TR><TR><TD style="padding: 2px;">Jane</TD><TD style="padding: 2px;">10007</TD><TD style="padding: 2px;">2015-01-03</TD></TR><TR><TD style="padding: 2px;">Sue</TD><TD style="padding: 2px;">10008</TD><TD style="padding: 2px;">2015-01-03</TD></TR></TBODY></TABLE><P></P><P>I need to calculate a column in the script to keep track of the number of orders the customer has ever placed. i.e.:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">OrderID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">OrderDate</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PurchaseNumber</TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;"><P>10001</P></TD><TD style="padding: 2px;">2015-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">10002</TD><TD style="padding: 2px;">2015-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Jane</TD><TD style="padding: 2px;">10003</TD><TD style="padding: 2px;">2015-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">10004</TD><TD style="padding: 2px;">2015-01-02</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">10005</TD><TD style="padding: 2px;">2015-01-03</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">10006</TD><TD style="padding: 2px;">2015-01-03</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">Jane</TD><TD style="padding: 2px;">10007</TD><TD style="padding: 2px;">2015-01-03</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">Sue</TD><TD style="padding: 2px;">10008</TD><TD style="padding: 2px;">2015-01-03</TD><TD style="padding: 2px;">1</TD></TR><TR><TD>John</TD><TD>10009</TD><TD>2015-01-03</TD><TD>3</TD></TR></TBODY></TABLE><P></P><P>This will allow me to tell that OrderID=10009 was John's third order ever. How do I calculate the PurchaseNumber column?</P></BODY></HTML> Wed, 16 Sep 2015 09:22:37 GMT https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961221#M648090 2015-09-16T09:22:37Z Re: Inter record counting https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961222#M648091 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Customer,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderId,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderDate,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; AutoNumber(OrderId, Customer) as PurchaseNumber</P><P>FROM ...</P></BODY></HTML> Wed, 16 Sep 2015 10:36:42 GMT https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961222#M648091 Gysbert_Wassenaar 2015-09-16T10:36:42Z Re: Inter record counting https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961223#M648092 <HTML><HEAD></HEAD><BODY><P>Brilliant, thank you!! </P></BODY></HTML> Wed, 16 Sep 2015 12:18:02 GMT https://community.qlik.com/t5/QlikView/Inter-record-counting/m-p/961223#M648092 2015-09-16T12:18:02Z