Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jacoas1989
New Contributor

Decrypt in Qlik SENSE

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?



Tags (2)