QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION

Who Me Too'd this solution

jagan
Luminary Alumni
Luminary Alumni

Hi Manoj,

The characters or bytes is the difference between the various has functions,

Hash functions in QlikView

In QlikView, the following hash functions are available:

autonumberhash128(): a 128 bit hash function that returns a 22 character string.

autonumberhash256(): 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.

Hope this helps you.

Regadrs,

Jagan.

View solution in original post

Who Me Too'd this solution