topic How to assign a unique number to each Year Month value? in App Development https://community.qlik.com/t5/App-Development/How-to-assign-a-unique-number-to-each-Year-Month-value/m-p/89461#M5957 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a YearMonth field where the values are like:</P><P></P><P>2015-Jan</P><P>2015-Feb</P><P>2015-Mar</P><P>etc</P><P></P><P>How can create a unique number that gets assigned to each value above? E.g. 2015-Jan would get 1, 2015-Feb would get 2... etc</P></BODY></HTML> Tue, 31 Jul 2018 16:30:48 GMT mwallman 2018-07-31T16:30:48Z How to assign a unique number to each Year Month value? https://community.qlik.com/t5/App-Development/How-to-assign-a-unique-number-to-each-Year-Month-value/m-p/89461#M5957 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a YearMonth field where the values are like:</P><P></P><P>2015-Jan</P><P>2015-Feb</P><P>2015-Mar</P><P>etc</P><P></P><P>How can create a unique number that gets assigned to each value above? E.g. 2015-Jan would get 1, 2015-Feb would get 2... etc</P></BODY></HTML> Tue, 31 Jul 2018 16:30:48 GMT https://community.qlik.com/t5/App-Development/How-to-assign-a-unique-number-to-each-Year-Month-value/m-p/89461#M5957 mwallman 2018-07-31T16:30:48Z Re: How to assign a unique number to each Year Month value? https://community.qlik.com/t5/App-Development/How-to-assign-a-unique-number-to-each-Year-Month-value/m-p/89462#M5958 <HTML><HEAD></HEAD><BODY><P>Try <STRONG>AutoNumber(YearMonth)</STRONG></P><P></P><P>but make sure that your YearMonth field is sorted in ascending order before you use AutoNumber</P></BODY></HTML> Tue, 31 Jul 2018 16:33:31 GMT https://community.qlik.com/t5/App-Development/How-to-assign-a-unique-number-to-each-Year-Month-value/m-p/89462#M5958 sunny_talwar 2018-07-31T16:33:31Z