topic Hide / modify information in QlikView

Hide / modify information

Mon, 15 Jul 2013 15:44:42 GMT

Hello QlikView gurus.

I have a technical question about hiding information. Let me explain myself. As a common practice, our consultant office asks us to modify every single job we do in qlikview, say, a SIB about sales, to transform every single row containing client names, item names, addresses, etc about our clients to a number, to say, Client Juan Pérez is transformed to Client 574, so we can use the work we did in future QlikView presentations, while protecting our clients privacy.

The problem is: we usually use the autonumber() function to do the job. But, now we have a QVW document without the source info (QVD's), so we can't modify the document using script.

There's a way to use functions directly on the listboxes expression, or in the straight/pivot/charts to transform the information? Like using something like the autonumber() or replace()?

Thanks in advance!!!!

Re: Hide / modify information

jerem1234 — Mon, 15 Jul 2013 15:57:54 GMT

Maybe the function Rand() would be of use?

Maybe something like:

='Cient ' & Round(rand()*1000, 1)

with the your dimension being the clients, and just hide that column

Re: Hide / modify information

swuehl — Mon, 15 Jul 2013 16:00:37 GMT

You can use the scrambing feature (document properties - scrambling) to scramble field values permanently (until next reload). This will render Juan Perez into something quite unreadable, give it a try 😉

I think you can also use the hash function in QV to scramble-like field values in the front end only, e.g. in a list box field expression:

=if(len(ClientName),hash128(ClientName))

but the real names are still in your data model!

Re: Hide / modify information

rustyfishbones — Mon, 15 Jul 2013 18:49:04 GMT

You can use hash128 (fieldname) in the script

Or you can click scramble go to

Settings

Document properties

Scrambling

Choose the field you want scrambled and click scramble