Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
hari8088
Creator
Creator

Hi

Hi how to use autonumberhash128 and 256 functions in script

4 Replies
ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Hari.

This same question was asked today by Manojqlik. Do you work together ?

what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Cheers,

Neil

datanibbler
Champion
Champion

Hi hari,

just look it up in the manual. It's quite easy.

Both of these functions can be used to hide, e.g. personell_numbers in a qlikView_application and replace them by arbitrary values. You just need to make sure that you don't have to process them any further and/or combine them with any other data.

Best regards,

DataNibbler

hari8088
Creator
Creator
Author

No neil,

             I  got the doubt

maxgro
MVP
MVP

usually in qlikview online help you can find the answer to this type of questions

example, copied from online help, in bold how to use in the script

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 )

autonumberhash256(expression {, expression})

Calculates a 256-bit hash of the combined input expression values and 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. This function is only available as a script function.

Example:

Autonumberhash256 ( Region, Year, Month )