4 Replies Latest reply: Mar 16, 2017 2:24 AM by Nauzad Doctor RSS

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

    Raj Biswas

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

        • Re: Is there any decryption process of a field in Qlik Sense?
          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?

          • Re: Is there any decryption process of a field in Qlik Sense?
            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