topic Scrambling and set analysis in QlikView

Scrambling and set analysis

terrorthijs — Thu, 22 Apr 2010 10:10:06 GMT

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

Scrambling and set analysis

Miguel_Angel_Baeyens — Thu, 22 Apr 2010 10:43:03 GMT

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...

Scrambling and set analysis

terrorthijs — Thu, 22 Apr 2010 15:20:29 GMT

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.

Scrambling and set analysis

Miguel_Angel_Baeyens — Thu, 22 Apr 2010 15:46:10 GMT

Hello Thijs,

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

Scrambling and set analysis

terrorthijs — Thu, 22 Apr 2010 16:21:16 GMT

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