Decrypt in Qlik SENSE

Anonymous — Tue, 07 Nov 2017 12:41:28 GMT

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?

topic Decrypt in Qlik SENSE in App Development