Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!
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!
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
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!
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