topic Re: Autonumber in qlikview in QlikView https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906156#M314883 <HTML><HEAD></HEAD><BODY><P>Also find the above example in a qvw file (PFA)</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 26 Apr 2015 12:51:28 GMT sunny_talwar 2015-04-26T12:51:28Z Autonumber in qlikview https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906154#M314881 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>please provide me some information .</P><P></P><P>Autonumber(company&amp;'#' &amp;department) as link </P><P></P><P></P><P>WHat does autonumber do in the above expression </P><P></P><P>Thanks in advance </P></BODY></HTML> Sun, 26 Apr 2015 12:33:23 GMT https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906154#M314881 Anonymous 2015-04-26T12:33:23Z Re: Autonumber in qlikview https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906155#M314882 <HTML><HEAD></HEAD><BODY><P>It will create a unique number for each unique instance of <STRONG>company&amp;'#'&amp;department</STRONG>. For instance if you have a table 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">company</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>department</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">AutoNumber(company&amp;'#'&amp;department)</TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">Finance</TD><TD style="padding: 2px; text-align: center;">1</TD></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">Marketing</TD><TD style="padding: 2px; text-align: center;">2</TD></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">Operations</TD><TD style="padding: 2px; text-align: center;">3</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">Finance</TD><TD style="padding: 2px; text-align: center;">4</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">Marketing</TD><TD style="padding: 2px; text-align: center;">5</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">Sales</TD><TD style="padding: 2px; text-align: center;">6</TD></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">Operations</TD><TD style="padding: 2px; text-align: center;"><STRONG style="color: #ff0000;">3</STRONG></TD></TR><TR><TD style="padding: 2px; text-align: center;">C</TD><TD style="padding: 2px; text-align: center;">Finance</TD><TD style="padding: 2px; text-align: center;">7</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">Sales</TD><TD style="padding: 2px; text-align: center;"><STRONG style="color: #ff0000;">6</STRONG></TD></TR></TBODY></TABLE><P></P><P>I hope the above example will help.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 26 Apr 2015 12:48:44 GMT https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906155#M314882 sunny_talwar 2015-04-26T12:48:44Z Re: Autonumber in qlikview https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906156#M314883 <HTML><HEAD></HEAD><BODY><P>Also find the above example in a qvw file (PFA)</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 26 Apr 2015 12:51:28 GMT https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906156#M314883 sunny_talwar 2015-04-26T12:51:28Z Re: Autonumber in qlikview https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906157#M314884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>alternatives could be:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14300531315279655 jive_text_macro" jivemacro_uid="_14300531315279655"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">AutonumberHash128(company, department) as link</SPAN></PRE><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">or</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14300531786138267" jivemacro_uid="_14300531786138267"> <P>AutonumberHash256(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">company, department</SPAN>) as link</P> </PRE><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">hope this helps</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Marco<BR /></SPAN></P></BODY></HTML> Sun, 26 Apr 2015 12:56:58 GMT https://community.qlik.com/t5/QlikView/Autonumber-in-qlikview/m-p/906157#M314884 MarcoWedel 2015-04-26T12:56:58Z