Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
terrorthijs
Partner - Contributor II
Partner - Contributor II

Scrambling and set analysis

Hi everyone,

I've used an application to make market shares visible for a customer. I've done this by using set analysis, using the name of the customer.

For a demo, i have to scramble the data, including the fields which contain the customer's name. This is messing up my set analysis. Is there a way around this?

greetings,

Thijs

4 Replies
Miguel_Angel_Baeyens

Hello Thijs,

I don't know whether you are using this feature already, but I'd give a try to the Cipher tab under the Document Properties. I've done that in version 9 some times without errors, just scrambling data. But of course it depends on the level of security you need to apply...

terrorthijs
Partner - Contributor II
Partner - Contributor II
Author

Yeah i've done that, but scrambling a field will also scramble the name of the client in those fields and thus my set analysis (in which the client's name is hardcoded) won't work.

Miguel_Angel_Baeyens

Hello Thijs,

You may then hardcode the scrambled name, as the scrambled output gives always the same value, although it may be very tedious...

terrorthijs
Partner - Contributor II
Partner - Contributor II
Author

That was exactly my problem... Not looking forward to it.