Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jacoas1989
Contributor
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?



0 Replies