topic Re: Generate an auto value for field in QlikView https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234013#M858620 <HTML><HEAD></HEAD><BODY><P>Take a look on: autonumber([User ID]) or maybe hash128([User ID]).</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 25 Jan 2017 12:20:39 GMT marcus_sommer 2017-01-25T12:20:39Z Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234012#M858619 <HTML><HEAD></HEAD><BODY><P>Hey everyone,</P><P></P><P>Im working on a tool that includes User Id's, but those Id's are part of the user's privacy.<BR />To counter that privacy problem, I want to generate an auto number for each user ID.</P><P></P><P></P><P>Like this for example.</P><P></P><P>ID000891 &gt; 138732</P><P>ID000892 &gt; 587453</P><P></P><P>Is it possible to change all user Id's to autogenerated values?</P><P></P><P>Thanks in advance,</P><P></P><P>Ivo</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234012#M858619 2020-11-25T16:16:04Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234013#M858620 <HTML><HEAD></HEAD><BODY><P>Take a look on: autonumber([User ID]) or maybe hash128([User ID]).</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 25 Jan 2017 12:20:39 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234013#M858620 marcus_sommer 2017-01-25T12:20:39Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234014#M858621 <HTML><HEAD></HEAD><BODY><P>Not sure about Hash128, but with AutoNumber, these unique ids would have a potential to change after each reload....</P></BODY></HTML> Wed, 25 Jan 2017 12:27:04 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234014#M858621 sunny_talwar 2017-01-25T12:27:04Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234015#M858622 <HTML><HEAD></HEAD><BODY><P>It worked! <BR />Thank you!</P></BODY></HTML> Wed, 25 Jan 2017 12:30:59 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234015#M858622 2017-01-25T12:30:59Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234016#M858623 <HTML><HEAD></HEAD><BODY><P>Yes the autonumber- respectively autonumberhash-functions could change with each reload and is therefore only within a single application "really" valid. But if you for example implement it within the generation of a dimension-table-qvd of the personal-data which is ordered or you made it ordered in an extra field - it could be applied over many applications either as the to displaying field with the origin User ID as key or the origin User ID could be replaced with it per mapping.</P><P></P><P>A pure hash-function instead will always return the same output by identical input-values.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 25 Jan 2017 12:52:04 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234016#M858623 marcus_sommer 2017-01-25T12:52:04Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234017#M858624 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/27943">marcus_sommer</A>‌ is Hash128 a pure hash-function?</P></BODY></HTML> Wed, 25 Jan 2017 12:55:08 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234017#M858624 sunny_talwar 2017-01-25T12:55:08Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234018#M858625 <HTML><HEAD></HEAD><BODY><P>Yes - I think so: <A href="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/" title="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/">http://www.qlikfix.com/2014/03/11/hash-functions-collisions/</A> and potential hash-collisions are rather not relevant.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 25 Jan 2017 13:04:43 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234018#M858625 marcus_sommer 2017-01-25T13:04:43Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234019#M858626 <HTML><HEAD></HEAD><BODY><P>So this survives load after load? and between different QVW files?</P></BODY></HTML> Wed, 25 Jan 2017 13:13:07 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234019#M858626 sunny_talwar 2017-01-25T13:13:07Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234020#M858627 <HTML><HEAD></HEAD><BODY><P>AFAIK - yes.</P></BODY></HTML> Wed, 25 Jan 2017 13:31:48 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234020#M858627 marcus_sommer 2017-01-25T13:31:48Z Re: Generate an auto value for field https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234021#M858628 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Jan 2017 13:36:42 GMT https://community.qlik.com/t5/QlikView/Generate-an-auto-value-for-field/m-p/1234021#M858628 sunny_talwar 2017-01-25T13:36:42Z