topic Re: autonumberhash? in QlikView

autonumberhash?

Tue, 28 Oct 2014 03:25:41 GMT

can anyone explain examples with autonumberhash128,autonumberhash256,?

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

Re: autonumberhash?

ashfaq_haseeb — Tue, 28 Oct 2014 05:17:32 GMT

Hi,

Check this

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

Regards

ASHFAQ

Re: autonumberhash?

jagan — Tue, 28 Oct 2014 05:26:42 GMT

Hi,

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

Regards,

Jagan.

Re: autonumberhash?

Wed, 29 Oct 2014 02:00:09 GMT

can u give small example

Re: autonumberhash?

jagan — Wed, 29 Oct 2014 02:49:15 GMT

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.

Re: autonumberhash?

jagan — Wed, 29 Oct 2014 06:12:20 GMT

Hi Manoj,

If you got the answer please close this thread.

Regards,

jagan.

Re: autonumberhash?

Wed, 29 Oct 2014 06:19:17 GMT

Hi,

here we have autonumberhash128(),autonumberhash256()

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

thanks in advance

Re: autonumberhash?

jagan — Wed, 29 Oct 2014 06:55:08 GMT

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.

Re: autonumberhash?

jagan — Wed, 29 Oct 2014 06:56:14 GMT

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.

Re: autonumberhash?

Wed, 29 Oct 2014 06:57:09 GMT

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

Re: autonumberhash?

ashfaq_haseeb — Wed, 29 Oct 2014 07:06:47 GMT

Hi if you have many expression.

Scroll is by default available.

If not try by resizing.

Regards

ASHFAQ

Re: autonumberhash?

jagan — Wed, 29 Oct 2014 07:10:30 GMT

Hi,

Scroll bars comes by default if you have more expressions or if the expression width is more than the actual table width.

If you got the answer please close this thread.

Regards,

jagan.

Re: autonumberhash?

Wed, 29 Oct 2014 07:13:21 GMT

sure. i have three expression but i am getting scroll bar right side of the object, thats ok i want it in down means x-axis , i got in y-axis

Re: autonumberhash?

jagan — Wed, 29 Oct 2014 07:17:35 GMT

Hi,

If you have more rows then you will get the scrollbar downwards.

Regards,

Jagan.