Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hash algorithm in buffer load QVDs

Hello together,

I would like to use the QVD functions like QvdCreateTime, QvdNoOfRecords on my non QVD tables.

Of course, I could explicitly store each table as a .qvd and then apply the features, but this would be a redundant step with already buffer loaded tables.

I could find the most detailed information about the way Qlikview generates the name of these buffer qvd files in another post ("Qlikview buffer load") here:

"The name of the QVD file is a calculated name (a 160-bit hexadecimal hash of the entire following load or select statement and other discriminating info)"

But this is not enough to use it - Can I store the information which is used to create that hash into a variable? What information is used (table name, field names, system time of generation, ...)? Which Hash algorithm is used (MD5, SHA1, ...)? Is that Hash-Type already implemented in the function hash256(), although this create a 43 char string and my qvd file name is 40 (plus 4 for ".qvd")?

If I get the answer that this information is confidential, a secret or so I would live with it, but I would be happy if someone could tell me.

Thx and BR

Dominik

0 Replies