Is there any decryption process of a field in Qlik Sense?

[shan_cse2003]

I have a Table in which one field value is in encrypted form,so is there any way to decrypt this.

[peter_turner]

Hello Raj,

As far as i know there are no decryption functions in QlikSense, but if you know the rules for the encryption (and its simple) it might be possible for you to write some script which will decrypt your values during the data load.

Alternatively can you pass a request from QlikSense to your data source and return the data in an unencrypted format?

[Michael_Tarallo]

Hello Raj - is this 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.

Thoughts?

NOTE: Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[#4]

Hi Mike,

Is there any workaround to decrypt data at the expression level? We have data that needs to be encrypted at rest, so we can't load it in through a stored proc and have decrypted data stored in the QVD.

Can we build an extension to have the data decrypt when the user opens up the app/sheet?

Thanks.

[Anonymous]

Hi Mike,

We've got a similar requirement as Ricky, 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.

Thanks