topic Re: Hash 128 in QlikView https://community.qlik.com/t5/QlikView/Hash-128/m-p/959636#M967244 <HTML><HEAD></HEAD><BODY><P>Barry has a great write up on his blog </P><P><A href="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/" title="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/">QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!</A></P><P></P><P>I personally have only used them on occasion and then generally I'm checking for a changed record as described by Barry. I've seem some developers use then Autonumberhash function to reduce a concatenated key to an integer. I don't care for this method as it's performance gains are negligible except in extreme scenarios and it destroys useful data by eliminating the possibility to parse out key values if needed. </P></BODY></HTML> Tue, 29 Sep 2015 14:10:41 GMT bme 2015-09-29T14:10:41Z Hash 128 https://community.qlik.com/t5/QlikView/Hash-128/m-p/959635#M967243 <HTML><HEAD></HEAD><BODY><P>Hi Just wanted to have a clear picture for this term -HASH 128 ?</P><P>What it is ,Why is it used ?</P><P>What other hashing functions we have ?</P><P><STRONG><BR /></STRONG></P><P><STRONG>What will this expression do -</STRONG></P><P><SPAN style="font-size: 12pt;"><STRONG style=": ; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-size: 12pt;">=$(='if('&amp;concat('NOT IsNull(['&amp;$Field&amp;'])',' AND ')&amp;', hash128('&amp; concat('['&amp;$Field&amp;']',',')&amp;'))' ) </SPAN></STRONG></SPAN></P></BODY></HTML> Tue, 29 Sep 2015 14:04:04 GMT https://community.qlik.com/t5/QlikView/Hash-128/m-p/959635#M967243 Pulkit_Thukral 2015-09-29T14:04:04Z Re: Hash 128 https://community.qlik.com/t5/QlikView/Hash-128/m-p/959636#M967244 <HTML><HEAD></HEAD><BODY><P>Barry has a great write up on his blog </P><P><A href="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/" title="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/">QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!</A></P><P></P><P>I personally have only used them on occasion and then generally I'm checking for a changed record as described by Barry. I've seem some developers use then Autonumberhash function to reduce a concatenated key to an integer. I don't care for this method as it's performance gains are negligible except in extreme scenarios and it destroys useful data by eliminating the possibility to parse out key values if needed. </P></BODY></HTML> Tue, 29 Sep 2015 14:10:41 GMT https://community.qlik.com/t5/QlikView/Hash-128/m-p/959636#M967244 bme 2015-09-29T14:10:41Z Re: Hash 128 https://community.qlik.com/t5/QlikView/Hash-128/m-p/959637#M967245 <HTML><HEAD></HEAD><BODY><P>See the help: <A href="https://betahelp.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/Hash128.htm" title="https://betahelp.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/Hash128.htm">Hash128</A></P><P></P><P>There are also Hash160 and Hash256 functions.</P></BODY></HTML> Tue, 29 Sep 2015 14:13:21 GMT https://community.qlik.com/t5/QlikView/Hash-128/m-p/959637#M967245 Gysbert_Wassenaar 2015-09-29T14:13:21Z