0 Replies Latest reply: Nov 7, 2017 7:41 AM by ana SULSISTROWSKI RSS

    Decrypt in Qlik SENSE

    ana SULSISTROWSKI

      Hello everyone,


      I have a problem decrypting a table in Qlik Sense.


      I've been reading and Qlik View can be done but not in Sense.


      This code works in View but not in Sense:


      //Encryption

      Cards_Encrytion:

       

      LOAD CARDNUMBER as Card_Number_ClearText,

      aesEncrypt(text(CARDNUMBER), '$(pwd)') as Card_Number_Encrypted,

          TXNCODE,

          POSTDATE

      FROM

      SourceTable.xls

      (biff, embedded labels, table is Sheet1$);

       

      STORE Cards_Encrytion into Cards_Encrypted.qvd(qvd);

       

      //Decryption

       

      NoConcatenate

       

      Cards_Decrytion:

       

      LOAD Card_Number_ClearText,

      aesDecrypt(text(Card_Number_Encrypted), '$(pwd)') as Card_Number_Decrypted

       

      FROM Cards_Encrypted.qvd(qvd);

       

      STORE Cards_Decrytion into Cards_Decrypted.qvd(qvd);

       

      The part in red is the one that fails in Sense.


      I have developped a  encryption program in Java with AES and I need to decrypt it with Qlik SENSE.


      Is there any solution to decrypt tables in Sense?