Re: Scrambling Qlik Sense data - Qlik Community

pauldamen · ‎2017-04-24

All,

In Qlikview there is a scrambling option. Is there something like that in Qlik Sense as well?

I need to scramble my data for demo purposes and don't feel like manually changing 20 fields

Regards, Paul

OmarBenSalem · ‎2017-04-24

Please refer to this document:

Scrambling Data

or to this thread :

Scramble data via the load script | Qlik Community

pauldamen · ‎2017-04-24

Hi,

found that post. I was hoping there would be an option in Sense without having the modify everything in the load script

Regards, Paul

OmarBenSalem · ‎2017-04-24

No, that does not exist 'unfortunately'

Anonymous · ‎2017-05-01

Hi Paul,

I find using Hash128() as a good alternative. You still have to do it in the load script, but if you don't have much to scramble, it's pretty easy. Once scrambled, there is no way for it be unscrambled.

Hash128(FieldName) as FieldName

There are other Hash functions but this one produces shorter strings than some of the others: Hash160(), Hash256().

Hope this helps.

Ricci

Anonymous · ‎2017-11-13

Hi Ricci,

It seems that data can easily 'unscrambled' by removing Hash***() and doing a reload.

regards

wim

JustinDallas · ‎2017-11-13

So the users can access and modify the script, as well as cause a manual reload?

Anonymous · ‎2017-11-13

in my opinion: yes.

Anonymous · ‎2017-11-13

Hi Paul,

Via the Dev Hub you can scramble your data. It worked for me rather then the Hash-method which can be reverted by a reload.

Please have a look at this link.

Data Scrambling in Qlik Sense | LinkedIn

regards,

Wim

rwunderlich · ‎2017-11-13

That's a great technique, thanks for posting.

It is no more or less secure than scrambling in the script using hash128(). If, as you suggested, the user has reload access, they can reload and undo the scrambling done by the API.

-Rob