Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Pulkit_Thukral
Partner - Creator II
Partner - Creator II

Hash 128

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&']',',')&'))' )

2 Replies
bme
Partner - Contributor III
Partner - Contributor III

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.

Gysbert_Wassenaar

See the help: Hash128

There are also Hash160 and Hash256 functions.


talk is cheap, supply exceeds demand