Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use Hash128 function in resolving synthetic key issue?

Hi All,

How to use Hash128 function in resolving synthetic key issue?

Please give an example. It would be great if provide a sample file.

Thanks in advance.

1 Solution

Accepted Solutions
its_anandrjs

Hi,

You can use it like below examples

From Qlikview Help


autonumberhash128(expression {, expression})

Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

Example:

autonumberhash128 ( Region, Year, Month )

Note:- Here Region, Year, Month individual table fields.

Regards

Anand

View solution in original post

3 Replies
Not applicable

insead of creating composit key like

field1 and filed2 and field3 as key       go with hash128

autonumberhash128(field1,field2,field3) as key

its_anandrjs

Hi,

You can use it like below examples

From Qlikview Help


autonumberhash128(expression {, expression})

Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

Example:

autonumberhash128 ( Region, Year, Month )

Note:- Here Region, Year, Month individual table fields.

Regards

Anand

View solution in original post

Not applicable


Hi,

If you have to create composite key just create a composite key using of autonumber function bcoz it is a optimization technique.it will give good performance while loading the data

Autonumberhash(field1,field2,field3) as Key_Field (or)

Autonumberhash128(field1,field2,field3) as Key_Field (or)

Autonumberhash256(field1,field2,field3) as Key_Field