Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please give me one simple example
Hi,
Scramble will change your column values into some different values, suppose for example if you have 100 in Sales it converts into 98 or 76 or any number randomly. If you have text field like country (USA) then it converted to some other text like abdce etc. It is useful when you are attaching in community so that the original values are changed or if you are giving demo to some other clients then this feature will come handy. Generally companies won't share data to others as such so the scrambling is done.
Hope this helps you.
Regards,
Jagan.
Hi,
Pls see below.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/14/scrambling-data
One use of this is when presenting confidential or proprietary information to outside people.
thanx
Hi,
Scramble will change your column values into some different values, suppose for example if you have 100 in Sales it converts into 98 or 76 or any number randomly. If you have text field like country (USA) then it converted to some other text like abdce etc. It is useful when you are attaching in community so that the original values are changed or if you are giving demo to some other clients then this feature will come handy. Generally companies won't share data to others as such so the scrambling is done.
Hope this helps you.
Regards,
Jagan.
Hi,
have a look at below post too. One such example.
http://community.qlik.com/docs/DOC-1290
Regards
ASHFAQ
Hi Jagan,
If I am not wrong. Are the Scramble function is decrepting the value from the outsider?.
Thanks
SD
We are encryting the values from outsiders.
Regards,
Jagan.
Hi Jagan,
Sorry, It is slip of my words. I mean encryting only i.e. masking the value.
Regard
SD
Yes. It will encrypt into some other values.
Regards,
Jagan.
Hi Jagan,
Thanks for the Reply, Can you please tell me...
1 ) How many ways are there for Scrambling
2) When We Reload our application all the Scrambling will get removed is there any way to avoid this...?
Regards,
Swapnil
Hi,
Method 1: Settings -> Document Properties -> Scrambling -> Select Fields and click on Scramble button.
Method 2: Use AutoNumber(), AutoNumberHash128(), AutoNumberHash256() for numeric fields and Has128(), Hash256() and Hash160() for string fields, this you need to use this in script like below
LOAD
AutoNumber(Sales) AS Sales,
Hash256(Customer) AS Customer
FROM DataSource;
Hope this helps you.
Regards,
Jagan.