How to apply Encryption in Qlik sense

[rathore01]

Hi,

I am fairly new to QS and want to implement encryption in my project.

Please guide me for the same.

I have searched a lot on community but unable to get encryption procedure for QS.

hic‌

[balabhaskarqlik]

May be this:

use encrypted application in qliksense without importing

[rathore01]

Thanks Bala for your suggestion.

But I am looking for field level encryption.

Please guide me if you have something in your bucket similar to this.

Thanks

[balabhaskarqlik]

May be this:

we need to be able to mask/hash the data in the QVD files, i.e. at rest. Some uses should be able to see the actual values, whereas some users should only see the masked values.

For encrypting data at rest we can use the Qlik hash128() / hash256() / autonumberhash functions to achieve this.

It would be great if we didn't have to create two Qlik Apps, 1 with masked data and 1 which is not masked.

Or check this:

https://community.qlik.com/docs/DOC-3359

Or

Table within an RDBMS?

If so, it may be possible to use a SQL dialect specific function or stored procedure with the RDBMS to decrypt the value before it comes into the Qlik index engine.

You can execute stored procedures with the SQL EXEC function:

LOAD xx, yy;

SQL EXEC sp_xxyy;

where xx and yy are the columns returned from the procedure sp_xxyy.