Hello,
I have the following problem: one of my client wants to give me encrypted data and want me to create dashbord from it.
When he connects to the application (using the access point), the user enter a passphrase that would decrypt the data.
The QVW application should never have the real data, and me, as administrator of the server, neither.
My first guess was to use an AES JavaScript function to decrypt values in the expressions. Unfortunatly, JS and VBS functions can only be called during script, not in expressions.
With the desktop client, I manage to do something with a "partial reload" that would take an existing table and reload it with a "decrypt" function (AES JS). Unfortunatly, the "partial reload" doesn't work on the access point.
I've made some progress with a macro using the "DynamicUpdateCommand" function.
To be simple, my client sends me data with all values divided by X, I load this data, and when he connects to the application, he has a button "decrypt" that do a DynamicUpdateCommand to multiply the encrypted fields by X.
This works fine, BUT... only if the user is on the "QlikView Administrators" Windows group, and it's not an option.
Do you have any idea how I can do that?
- The server have to never have the decrypted data.
- Any user / admin server side can have access to the decrypted data.
- Only user on the access point with the correct key can see the decrypted data.
Thank you.
