Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone explain examples with autonumberhash128,autonumberhash256,?
pls i have seen in help but i was not clear with that ?
Hi,
Autonumberhas128() & autonumberhash256 will encrypt the data into some other values, sometimes this functions are used to generate the key fields.
Regards,
Jagan.
Hi,
Autonumberhas128() & autonumberhash256 will encrypt the data into some other values, sometimes this functions are used to generate the key fields.
Regards,
Jagan.
can u give small example
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.
Hi Manoj,
If you got the answer please close this thread.
Regards,
jagan.
Hi,
here we have autonumberhash128(),autonumberhash256()
but in which situation we can use autonumberhash128() and which situation we can use autonumberhash256()
thanks in advance
Hi Rakesh,
Hash functions in QlikView
In QlikView, the following hash functions are available:
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.
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.
pivot x-axis scroll bar need to create how? is it possible in pivot?