Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

Scramble Sensitive Data In Qlik Cloud

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniele_Purrone
Support
Support

Scramble Sensitive Data In Qlik Cloud

Last Update:

Dec 1, 2023 2:29:37 AM

Updated By:

Sonja_Bauernfeind

Created date:

Nov 8, 2022 10:34:11 AM

Attachments

Qlik Sense data files (.QVF) may contain sensitive organizational data.  As such, even though Qlik Technical Support has a very strict Non-Disclosure Agreement, it may be desired to  scrambled specific data before submitting apps Qlik Sense support for investigation.

For the currently available method in Qlik Sense Enterprise for Windows, see Scramble Sensitive Data In Qlik Sense Enterprise for Windows.

Data can be scrambled in two ways:

Before providing the scrambled application to Qlik Support, please check that you can still reproduce the issue within the scrambled application.

Using Qlik Application Automation

The attached automation_scramble_Support.json automation creates a copy of your app before scrambling the data. 

Requirements:

  • the app must be stored in a Shared Space (not a Personal Space or Managed Space)
  • the user running the automation must have access to the Shared Space
  • the tenant must have the Automation feature enabled; scrambling data using Qlik Application Automation is not available in Qlik Sense Business or Qlik Cloud Analytics Standard

To scramble your data using the automation:

  1. Download automation_scramble_Support.json
  2. Open your Qlik Cloud hub
  3. Create a new Automation

    new automation.png

  4. Select Blank automation
  5. Right-click the blank automation workspace and click Upload Workspace (see How to import and export automations)
  6. Select and upload automation_scramble_Support.json
  7. Configure the automation:
    1. Click the Get App Information block
    2. Add your app's ID in App Id

      get app information.png

  8. Click Run to run the automation
  9. A copy of your app named Scrambled_YourAppName is created

 

Using a predefined Excel sheet

If Automations are not enabled, or you do not have the correct subscription model, use the attached Qlik Script and Excel file to scramble the data. 

To scramble data using an excel file and a Qlik script:

  1. Duplicate the app in the Cloud hub
  2. Review the app and work out the list of fields (and related tables) you want to scramble. Replace the contents in the metadata file scramble.xlsx with the list.
  3. Upload both the edited scramble.xlsx and scramble.qvs (attached to this article) to a space in your tenant
  4. On the duplicated app, paste the following script into the app script editor before any other script statement, including the SET variable statements (which should have been removed or commented out). Substitute the file names stored in the Binary data source location accordingly.
    Binary;
    $(Include=lib://NAMEOFSPACE:DataFiles/scramble.qvs);

    CALL Scramble('lib://NAMEOFSPACE:DataFiles/scramble.xlsx');

    Exit Script;
  5. Reload the duplicated app and review the result
  6. Export the app from the hub

Related Content:

Idea / Feature Request - Data Masking 
Alternative method using APIs and the DevHub: Data Scrambling in Qlik Sense 
Scramble Sensitive Data In Qlik Sense Enterprise for Windows
To access the examples, visit the community post or download it from here

 

Environment

Qlik Cloud 

Labels (1)
Comments
Shohamgg
Contributor II
Contributor II

Congrats on adding the Automation.

I Just used it.

You should mention that  you can not use it on models in manged spaces.

Is it not true that the "Copy App" block does not work on them?

It also broke some of my KPIs 🙂 but I didn't look into why just yet.

Thanks

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Shohamgg 

The requirement is already listed here. I will highlight the section to make it more prominent. 

All the best,
Sonja 

Version history
Last update:
‎2023-12-01 02:29 AM
Updated by: