topic Re: Using the SHA256() function in Archived Groups

Using the SHA256() function

ceosis79 — Tue, 22 Jul 2025 14:42:16 GMT

We construct with four fields a concatenated code without special characters (no accents, no hyphens) or capital letters, assembled with pipe characters: |

This code is then hashed with a SHA256 function.

Example

Will have initial code: demezancon|jeanfrancois|21121987|99129

Once hashed: 2a5bc014151a1b36c93ae134100f6f474283712d91d58f51ddc169fa3224a7b3

But when I use the following function: Hash256('demezancon|jeanfrancois|21121987|99129')

I get a totally different result: LS;:]<+<%&GT::)U9:#&Q<58`EWE<>RU!KGN:8ZS,EU

I can't figure out what's missing in my formula to get the expected result.

Thank you in advance for your help.

Re: Using the SHA256() function

Anil_Babu_Samineni — Sun, 10 Mar 2024 00:21:27 GMT

@ceosis79 As per this, Hash256 - script and chart function | Qlik Sense on Windows Help It seems the result is OK?

But, The title says SHA256()?

Re: Using the SHA256() function

jmmayoral3 — Sun, 10 Mar 2024 08:23:07 GMT

Hello Ceosis.
I would need to know how you are concatenating the fields and how you are using that concatenation in hash256() so that it returns 2a5bc014151a1b36c93ae134100f6f474283712d91d58f51ddc169fa3224a7b3
Because I have used this script :

My_TABLE:

load *, a&'|'&b&'|'&c&'|'&d as h;
LOAD * INLINE[
a,b,c,d
demezancon,jeanfrancois,21121987,99129
];

and the results that always give me the same:

hash256(a&'|'&b&'|'&c&'|'&d) --> LS;:]<+<%&GT::)U9:#&Q<58`EWE<>RU!KGN:8ZS,EU

hash256(h) --> LS;:]<+<%&GT::)U9:#&Q<58`EWE<>RU!KGN:8ZS,EU

hash256('demezancon|jeanfrancois|21121987|99129') --> LS;:]<+<%&GT::)U9:#&Q<58`EWE<>RU!KGN:8ZS,EU

Except when I use this sentence:

hash256(a,b,c,d) --> HP"^B!*T9M.%"*(6D4F.16PV>_%#:GL<U[C]LZR\\H#

Re: Using the SHA256() function

ceosis79 — Sun, 10 Mar 2024 09:18:05 GMT

Hello @jmmayoral3 and @Anil_Babu_Samineni

The example is provided by my central administration, when I saw a different output I checked the calculation with various online tools and get the same result than the example :

https://passwordsgenerator.net/sha256-hash-generator/
https://emn178.github.io/online-tools/sha256.html
https://tools.keycdn.com/sha256-online-generator

Maybe the Qlik Sense function hash256() needs a specific argument to define the proper algorithm or I need to use an other function.

Could you guys help tel me how to achieve this in Qlik Sense ?

Re: Using the SHA256() function

Anil_Babu_Samineni — Sun, 10 Mar 2024 16:06:17 GMT

@ceosis79 Can we know what you want to use after you use below one?

Hash256('demezancon|jeanfrancois|21121987|99129').

I can see @jmmayoral3 explained the same how Qlik works.

Re: Using the SHA256() function

rwunderlich — Mon, 11 Mar 2024 04:10:30 GMT

Qlik Hash256() does not use the same hashing algorithm as SHA256(). SHA256() would use SHA, while Hash256() apparently uses something different.
https://support.qlik.com/articles/000026464

You'll find other questions in this forum about how to possibly replicate SHA256 in Qlik Sense. I don't think it's possible without using an external routine like an SSE.

-Rob

Re: Using the SHA256() function

ceosis79 — Mon, 11 Mar 2024 08:42:27 GMT

Thanks Rob, for your explanation.

It's clear now that Qlik Sense function Hash256() is not a solution for me to provide this encrypted field in the format I have to deliver.

I should have notice like @Anil_Babu_Samineni the subtle difference between SHA256 and HASH256 !

Sorry to have bother you three with this beginner's question…

Best regards
Vladimir