Autohash returns a unique integer value for each distinct value you define.
This is mostly used for joins.
For example:
1. Define Join without AutoHash (using concatenated strings):
* field_A&'-'&field_B AS Key
2. Define Join with Autonumber you can define it this way:
* autonumberhash128(Field_A,Field_B) AS Key
See more in the Qlikview Help:
--------------------------------------------------------------------------------------------------------------------------------------------------
autonumberhash128(expression {, expression})
Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.
Example:
autonumberhash128 ( Region, Year, Month )
