Jan 14, 2021 / Rob Wunderlich

Have you ever wanted to obfuscate or hide some data in your Qlik App?  Perhaps because you wanted to share a copy of the app outside your organization? Or demo to an audience that is not authorized to see details like employee or customer names?

QlikView had a “Scramble Field” feature in Document Properties, Qlik Sense does not.  A really nice option available in both products is the AutoNumber script statement. Place it at the end of your script, listing the fields you want to obfuscate. The values will be translated to integers and cannot be translated back by prying eyes.

AutoNumber [Customer Name], SSN, [Customer Contact], Commission;

The AutoNumber statement runs super fast. No more than a few seconds even on a very large model.

-Rob

On Jan 20, 2021 I’ll be teaching “Advanced Scripting” as part of the “Masters Summit at Home” series.  Learn more.