Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to shuffle/anonymate records


I have several problems

1. Suppose I have a table like this:


I want to shuffle (anonymate, or how to say it - to make the records untraceable and anonymous that do not match the original records) like this:

shuffled_name (desired result)shuffled_surname (desired result)

To test, it is pretty easy: IF(name = shuffled_name AND surname = shuffled_surname; 1, 0); then SUM and if result > 0 a record hasn't been shuffled properly. But the question is how to do it?

2. Suppose I have a table like this:

productanonymated product (desired result)
shampooproduct 1
soapproduct 2
soapproduct 2
bath gelproduct 3
shampooproduct 1

It would be easy to do if the records would all be unique, but how to do it if there are duplicates like in the table below?

3. Suppose I have a table like this:

addressanonymated address (desired result)
Johnson Street 15address 1
Gary Street 96address 2
Jackson Avenue 22address 3
Gary Street 96address  2
Johnny Street 21address 4

Again, it would be very easy to do if all the records would be unique and there would be no empty or <null> values.

4. Also, what would be the best way to explore the data - suppose you have a huge transactions or sales table, and 10± other ones, is it better to use easyqlikviewer or to import all the data and to vizualize and search it? And why?

Thank you,


2 Replies
Partner - Champion III
Partner - Champion III

QlikView Desktop has a feature to scramble fields (not entire rows or you may lose your links). It works by replacing the current textual values in the symbol table of a field with scrambled data (just plain unreadable jibberish but not garbage data). See Settings->Document Properties->Scrambling

This feature is typically used for anonymizing data that shouldn't be transmitted to any outside party (which creates problems when for example you want help with the design of your document  from a remote 3rd party)

However, AFAIK you cannot dictate what those scrambled values should look like. For that, you may need to design and implement a translation of your own. For example, replace all product names with "Product "+index number of the original field value (or autonumber). May require quite a few mapping tables


#2 and #3, can be solved using autonumber function.

LOAD address,

     'Address ' and autonumber(address) as anonymated_address


For #1,

probably you can use something like:

LOAD name, above(surname) as surname