Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsIf you scramble data in your file and reload it, fresh data will be loaded and the fields will not be scrambled anymore.
There is no way to maintain scrambled fields after a reload, since you are loading new data.
Environment: QlikView, any version.
An option that you can use is setting up a trigger, calling a macro, on post reload, to scramble the data for you.
With this option the data will be re-scrambled every reload.
Macro code:
Sub Scramble
ActiveDocument.ScrambleField "YOUR_FIELD",true
End Sub
To set a trigger, you will have to go to Document properties -> Triggers
Select OnPostReload option
Create a Run Macro action with the code above.
<Macros are not supported by Qlik>
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSearch Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a caseExperiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us