Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Just wanted to have a clear picture for this term -HASH 128 ?
What it is ,Why is it used ?
What other hashing functions we have ?
What will this expression do -
=$(='if('&concat('NOT IsNull(['&$Field&'])',' AND ')&', hash128('& concat('['&$Field&']',',')&'))' )
Barry has a great write up on his blog
QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!
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.
See the help: Hash128
There are also Hash160 and Hash256 functions.