Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shan_cse2003
Contributor II
Contributor II

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

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

4 Replies
peter_turner
Partner - Specialist
Partner - Specialist

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
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
Not applicable

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
Not applicable

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