autonumberhash?

[#1]

can anyone explain  examples with autonumberhash128,autonumberhash256,?

pls i have seen in help but i was not clear with that ?

[ashfaq_haseeb]

Hi,

Check this

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

Regards

ASHFAQ

[jagan · Accepted solution]

Hi,

Autonumberhas128() & autonumberhash256 will encrypt the data into some other values, sometimes this functions are used to generate the key fields.

Regards,

Jagan.

[#4]

can u give small example

[jagan]

Hi,

Try like this

Data:

Load

AutoNumberHash256(Country, City) AS CountryCityID,

Country ,

City

Inline [

Country, City

India, Mumbai

UK, London

USA, Newyork

];

In the above script based on Country and City we are generating a key field.  Hope this helps you.

Regards,

Jagan.

[jagan]

Hi Manoj,

If you got the answer please close this thread.

Regards,

jagan.

[#7]

Hi,

here we have autonumberhash128(),autonumberhash256()

but in which situation we can use autonumberhash128() and which situation we can use autonumberhash256()

thanks in advance

[jagan]

Hi Rakesh,

Hash functions in QlikView

In QlikView, the following hash functions are available:

• Hash128(): a 128 bit hash function that returns a 22 character string.
• Hash160(): a 160 bit hash function that returns 27 character string.
• Hash256(): a 256 bit hash function that returns a 43 character string.

The number of bits determines the output range of the function. A 128 bit hash can store 2^128 (or, 340.282.366.920.938.000.000.000.000.000.000.000.000) different combinations. 160 and 256 bit can store even more combinations (2^160 and 2^256 respectively).

Besides these functions, QlikView also has the AutoNumberHash128() and AutoNumberHash256()functions. These functions basically take the output of the Hash128() and Hash256() function and passes it through the AutoNumber() function. While I think they have a nicer syntax than the regularAutoNumber(), you can supply a comma-separated list of fields instead of a concatenated string, the usefulness of these functions eludes me.

Regards,

Jagan.

[jagan]

Hi Rakesh,

Also check this link

QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!

The above post is part of this thread.

Regards,

Jagan.

[#10]

pivot x-axis scroll bar need to create how? is it possible in pivot?