topic Convert text to integer in QlikView https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145913#M24558 <HTML><HEAD></HEAD><BODY><P>Hello folks.</P><P>I'm trying to create a new field for counting unique people in our db. I'm concatenating First Name, Last Name, Carrier, and Birth date.</P><P>First Name, Last Name and Carrier are all text fields, and would like to get the numerical value for those fields.</P><P>Is this possible?</P></BODY></HTML> Thu, 04 Jun 2009 20:57:38 GMT 2009-06-04T20:57:38Z Convert text to integer https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145913#M24558 <HTML><HEAD></HEAD><BODY><P>Hello folks.</P><P>I'm trying to create a new field for counting unique people in our db. I'm concatenating First Name, Last Name, Carrier, and Birth date.</P><P>First Name, Last Name and Carrier are all text fields, and would like to get the numerical value for those fields.</P><P>Is this possible?</P></BODY></HTML> Thu, 04 Jun 2009 20:57:38 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145913#M24558 2009-06-04T20:57:38Z Convert text to integer https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145914#M24559 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>quick shot: try autonumber (see QV Help File for more information).</P><P>Rainer</P></BODY></HTML> Thu, 04 Jun 2009 21:01:41 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145914#M24559 2009-06-04T21:01:41Z Convert text to integer https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145915#M24560 <HTML><HEAD></HEAD><BODY><P>Yes it is possible. The function you are looking for is autonumberhash128(expression {, expression})</P><P>or autonumberhash256(expression {, expression}) (which is for a larger number of combinations).</P><P>See page 413-415 in the Reference Manual</P><P style="font-weight: bold"></P></BODY></HTML> Thu, 04 Jun 2009 21:27:51 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145915#M24560 2009-06-04T21:27:51Z Convert text to integer https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145916#M24561 <HTML><HEAD></HEAD><BODY><P>Works great. Thanks for the help guys.</P></BODY></HTML> Thu, 04 Jun 2009 22:22:35 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-integer/m-p/145916#M24561 2009-06-04T22:22:35Z