topic Keep data scrambled on reload in QlikView

Keep data scrambled on reload

Tue, 04 May 2010 22:59:47 GMT

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

Keep data scrambled on reload

rwunderlich — Tue, 04 May 2010 23:06:26 GMT

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

-Rob

Keep data scrambled on reload

Tue, 04 May 2010 23:09:43 GMT

Use this macro to run OnPostReload

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

Keep data scrambled on reload

Wed, 05 May 2010 16:01:05 GMT

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

Thanks again,

Rob

Keep data scrambled on reload

Thu, 08 Dec 2011 20:11:28 GMT

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.