What is the use of autonumberhash128?

[#1]

How is it different from autonumber..and why we need to use autonumber

[#2]

Hi Haimanta,

have a look at this thread maybe

http://community.qlik.com/message/322226#322226

hope that helps

Joe

[yduval75]

Hello,

Autonumber stores the expression value and gives it a unique integer value whereas autonumberhash128 stores just the hash value (in 128 bits) of the corresponding expression value.

[its_anandrjs]

Hi,

From the Qlik Help

autonumber(expression[ , AutoID])

Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

In order to create multiple counter instances if the autonumber function is used on different keys within the script, an optional parameter AutoID can be used for naming each counter.

Examples:

autonumber( Region&Year&Month )

autonumber( Region&Year&Month, 'Ctr1' )

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 )

Regards

Anand

[Anonymous]

Hi,

autonumberhash128 stores just the hash value (in 128 bits) of the corresponding expression value.

Regards

Neetha