Scramble Sensitive Data In Qlik Cloud

Daniele_Purrone — Mon, 04 May 2026 12:14:18 GMT

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 three 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:

Download automation_scramble_Support.json
Open your Qlik Cloud hub
Create a new Automation
Select Blank automation
Right-click the blank automation workspace and click Upload Workspace (see How to import and export automations)
Select and upload automation_scramble_Support.json
Configure the automation:
1. Click the Get App Information block
2. Add your app's ID in App Id
Click Run to run the automation
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:

Duplicate the app in the Cloud hub
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.
Upload both the edited scramble.xlsx and scramble.qvs (attached to this article) to a space in your tenant
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;
```
Reload the duplicated app and review the result
Export the app from the hub

Using A PowerShell Script

It is possible to generate a scrambled version of any app with the PowerShell script in the attached QlikScramble.ps1 file.

This can be done from any machine that can access the tenant where the app is located. The requirements for these options are:

PowerShell version 7.6 or later.
Qlik CLI is installed and set up on the machine.

Steps:

Download the QlikScramble.ps1.txt file from this article.
Save it in a folder you can access and remove the .txt extension.
Right-click the file > Properties > General, and ensure the file is not blocked. In case, flag the "Unblock" option.
Open PowerShell as administrator.
Locate the folder where you saved the file
cd "PathToFile"
Run the .ps1 file: .\QlikScramble.ps1
A window opens with the list of the apps in your tenant.
Select the app you want to scramble from the window and click OK.
Select the fields to scramble in the window that opens. You can select as many dimensions and expressions you want with CTRL + left click.
Click on OK.
A new scrambled app is created with the name SCRAMBLED_originalAppName.

Environment

Re: Scramble Sensitive Data In Qlik Cloud

Shohamgg — Thu, 30 Nov 2023 16:57:18 GMT

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

Re: Scramble Sensitive Data In Qlik Cloud

Sonja_Bauernfeind — Fri, 01 Dec 2023 07:28:51 GMT

Hello @Shohamgg

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

All the best,
Sonja

article Scramble Sensitive Data In Qlik Cloud in Official Support Articles

Scramble Sensitive Data In Qlik Cloud

Using Qlik Application Automation

Requirements:

Using a predefined Excel sheet

Using A PowerShell Script

Related Content:

Environment

Re: Scramble Sensitive Data In Qlik Cloud

Re: Scramble Sensitive Data In Qlik Cloud