Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
bibopipo
Creator II
Creator II

Autonumberhash function

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

1 Solution

Accepted Solutions
sreenivas
Creator III
Creator III

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

View solution in original post

4 Replies
sreenivas
Creator III
Creator III

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

khadeer
Specialist
Specialist

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

bibopipo
Creator II
Creator II
Author

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

farolito20
Contributor III
Contributor III

I prefer into de loading from db