Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can Sense leverage this QV Encryption script?

This is quite interesting and wanted to see if anyone can confirm this works in Sense

https://community.qlik.com/message/304652

or

Encryption in QlikView — Medium

Thanks!

1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

The AES functions are there, but there are some hashing functions:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash128.htm

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash160.htm

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash256.htm

So to use the Hash256 function here is a sample script:

TestData:

LOAD * INLINE [

Person,FICO

Bob, 750

Alice, 700

John, 750

James, 600 ];

Hashing:

LOAD

//Person as PersonHash,

hash256([FICO]) as [FICOHash]

Resident TestData;

View solution in original post

2 Replies
Levi_Turner
Employee
Employee

The AES functions are there, but there are some hashing functions:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash128.htm

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash160.htm

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash256.htm

So to use the Hash256 function here is a sample script:

TestData:

LOAD * INLINE [

Person,FICO

Bob, 750

Alice, 700

John, 750

James, 600 ];

Hashing:

LOAD

//Person as PersonHash,

hash256([FICO]) as [FICOHash]

Resident TestData;

Not applicable
Author

Thank you Levi!