topic Re: Autonumberhash function in QlikView

Autonumberhash function

Anonymous — Wed, 02 Jan 2013 09:29:20 GMT

Dear all,

I would understand how to use the function in object. I've several tables linked by a very long char & number keys (for example Customer & year & month & contract & order & coutnry ....)

I have read that using this function, is possible to reduce RAM usage and speed up Qlikview applications.

May I have any further in order to understand how can I use it and when ?

Thanks in advance for your help

Re: Autonumberhash function

sreenivas — Wed, 02 Jan 2013 09:39:53 GMT

AutoNumber(Customer & year & month & contract & order & coutnry) as FieldKey

Re: Autonumberhash function

khadeer — Wed, 02 Jan 2013 10:25:13 GMT

Autonumber, Autonumberhash128, Autonumberhash256 functions used for same thing.

It automatiacally generate an unique number. Basically we use in creating keys like composite keys.It will give the exact result.It will reduce the RAM usage also. Whenever u r creating composte keys it will be best to use autonumber function. For more read help n check in reference manual.

Regards,

Khadeer

Re: Autonumberhash function

Anonymous — Wed, 02 Jan 2013 13:38:11 GMT

Thanks for your answer,

but two questions are occuring in my mind:

- is there any performance differences using autonumber, autonumberhash128 or 256 ?

- when is it better to use them ? My application is composed by two docs: the first one reads all table from the db and stores them into qvd files, the second one retrieve data from qvd files and provides to create reports, graphs,..

The question is: is it better to use autonumber into the loading from db or later ?

Thanks in advance fo your suggestions

Re: Autonumberhash function

farolito20 — Wed, 02 Jan 2013 19:44:08 GMT

I prefer into de loading from db