Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner - Creator II
Partner - Creator II

Scrambling Qlik Sense data

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

10 Replies
OmarBenSalem
Partner - Champion II
Partner - Champion II

Please refer to this document:

Scrambling Data

or to this thread :

Scramble data via the load script | Qlik Community

pauldamen
Partner - Creator II
Partner - Creator II
Author

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
Partner - Champion II
Partner - Champion II

No, that does not exist 'unfortunately'

bec
Employee
Employee

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

wim_embrechts
Contributor III
Contributor III

Hi Ricci,

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

regards

wim

JustinDallas
Specialist II
Specialist II

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

wim_embrechts
Contributor III
Contributor III

in my opinion: yes.

wim_embrechts
Contributor III
Contributor III

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

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