Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Keep data scrambled on reload

Hi All,

I am building an application which has some data that I would prefer the end users to not see the real values of, but I do want them to see the field. I know I can do this via the "Scramble" tab on the document after it is loaded, but when the reload is run, the scrambling is lost. So, it seems to me that the Scramble function at that level is great for doing a demo, but not on an operational basis.

Is there a way to scramble a field in the load script, or preserve the scrambling after the reload ?

Thanks for your help!

Rob

P.S. I am using v 8.5

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You could do your own scrambling in the load script with the hash128() function.

-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You could do your own scrambling in the load script with the hash128() function.

-Rob

Not applicable
Author

Use this macro to run OnPostReload

Sub Scramble
ActiveDocument.ScrambleField "Field",false
End Sub

Not applicable
Author

Thanks to both of you, both of your ides work!!

Thanks again,

Rob

Not applicable
Author

Is there any way to scramble a substring on the OnPostReload?  For example, if I field "ABDC123", I only want to only scramble the first 4 characters.