Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dec 9, 2020 9:12:12 AM
Apr 26, 2019 7:02:39 AM
This document applies when using Qlik Sense Desktop, and serves as a companion to the article that contains steps when using Qlik Sense Enterprise found under Scramble Sensitive Data In Qlik Sense.
It may be necessary to scramble the data in a QVF to be able to share it for troubleshooting purposes. Unfortunately, data scrambling is not available as a feature in the current Qlik Sense product.
This document shares a method and related scripts on how to scramble sensitive data in Qlik Sense app until the feature is built into Qlik Sense.
Steps:
Binary lib://Binary/<filename>.qvf; $(Include=lib://Binary/scramble.qvs); CALL Scramble('<name of metadatafile>.xlsx');
Other consideration:
If the app has "Legacy Mode" enabled, above steps 1~6 can be skipped and use file path directly in the load script in step 7, for example code as below:
Binary C:\Users\xxx\abc\<filename>.qvf; $(Include=C:\Users\xxx\abc\scramble.qvs); CALL Scramble('C:\Users\xxx\abc\<name of metadatafile>.xlsx');
NOTE: Sometime sensitive data such as organisation name will also be in metadata's table or field name. User will need to manually call rename() function in load script to remove it;
Also check this link for an alternative scrambling method using the APIs and the DevHub
Hello @Sonja_Bauernfeind,
thank you. Your method works fine.
Is it possible to scramble numeric fields in a way, that the numbers in the numeric fields get scrambled/changed?
Example: 123 to 637, 345 to 149, etc...
Thank you. Best regards, Patrick