topic autonumber? in QlikView https://community.qlik.com/t5/QlikView/autonumber/m-p/827214#M1042190 <HTML><HEAD></HEAD><BODY><P><BR />autonumber(sales)*100 as nsales&nbsp; ?&nbsp;&nbsp; what it returns ?</P></BODY></HTML> Mon, 15 Dec 2014 16:06:55 GMT 2014-12-15T16:06:55Z autonumber? https://community.qlik.com/t5/QlikView/autonumber/m-p/827214#M1042190 <HTML><HEAD></HEAD><BODY><P><BR />autonumber(sales)*100 as nsales&nbsp; ?&nbsp;&nbsp; what it returns ?</P></BODY></HTML> Mon, 15 Dec 2014 16:06:55 GMT https://community.qlik.com/t5/QlikView/autonumber/m-p/827214#M1042190 2014-12-15T16:06:55Z Re: autonumber? https://community.qlik.com/t5/QlikView/autonumber/m-p/827215#M1042191 <HTML><HEAD></HEAD><BODY><P>it will give you the output as 100,200,300 depending on the distinct rows of sales you have in your data.</P><P></P><P>Regards</P><P>Saurabh</P></BODY></HTML> Mon, 15 Dec 2014 16:11:07 GMT https://community.qlik.com/t5/QlikView/autonumber/m-p/827215#M1042191 saurabh5 2014-12-15T16:11:07Z Re: autonumber? https://community.qlik.com/t5/QlikView/autonumber/m-p/827216#M1042192 <HTML><HEAD></HEAD><BODY><P>It will AutoNumber each distinct Sales with 1, 2 ,3 ,4 etc.. and then multiply with 100</P><P></P><P>So if you have</P><P>Sales as </P><P>100</P><P>100</P><P>100</P><P>120</P><P>120</P><P>130</P><P></P><P>it will give </P><P>Sales&nbsp;&nbsp;&nbsp;&nbsp; nsales</P><P>100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>130&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P></BODY></HTML> Mon, 15 Dec 2014 16:11:57 GMT https://community.qlik.com/t5/QlikView/autonumber/m-p/827216#M1042192 MK_QSL 2014-12-15T16:11:57Z