topic Need some example for autonumber128 with output! in QlikView

Need some example for autonumber128 with output!

Thu, 19 Aug 2010 07:36:32 GMT

What is the use of autonumberhash128? Can any one explain me with some example.

By the way what is mean by "returns a unique integer value for each distinct hash value" ? Does it mean that it will return unique integer value for Region, Year and Month separately ? Or together it will generate unique value. Please explain the same with example and output as given example is not good enough to understand.

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 )

Need some example for autonumber128 with output!

Thu, 19 Aug 2010 07:48:50 GMT

Look at the examplem attached.

Need some example for autonumber128 with output!

suniljain — Thu, 19 Aug 2010 08:35:17 GMT

autonumberhash128(Region,year,Nonth)

It Generate Indexing based on whatever parameter you set as expression.

Need some example for autonumber128 with output!

suniljain — Thu, 19 Aug 2010 08:36:19 GMT

Expression should be distinct hash value.

Need some example for autonumber128 with output!

Thu, 19 Aug 2010 10:38:15 GMT

Hi Santhosh,

Many thanks for your help. Seeing the document I feel it generates 1 key value for all the expression value combined together. I was just thinking that it will generate key value for each expression field. I got confused as it was not showing any value in the assigned variable as shown below.

SET PKexp=autonumberhash128(stkcode,stkname);

Document attached by you helped me to understand easily.

Need some example for autonumber128 with output!

Thu, 19 Aug 2010 10:59:29 GMT

Hi Sunil,

Thanks for the explanation.