topic Re: Hi in QlikView

Hi

hari8088 — Mon, 07 Jul 2014 12:42:44 GMT

Hi how to use autonumberhash128 and 256 functions in script

Re: Hi

ngulliver — Mon, 07 Jul 2014 12:47:19 GMT

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

Re: Hi

datanibbler — Mon, 07 Jul 2014 12:48:37 GMT

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

Re: Hi

hari8088 — Mon, 07 Jul 2014 12:51:58 GMT

No neil,

I got the doubt

Re: Hi

maxgro — Mon, 07 Jul 2014 12:52:40 GMT

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 )