topic Re: What is scrambling & Why to Use it.... in QlikView

What is scrambling & Why to Use it....

sgg_gaikwad — Wed, 20 Aug 2014 09:51:35 GMT

Please give me one simple example

Re: What is scrambling & Why to Use it....

senarath — Wed, 20 Aug 2014 09:56:56 GMT

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

Re: What is scrambling & Why to Use it....

jagan — Wed, 20 Aug 2014 10:15:23 GMT

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.

Re: What is scrambling & Why to Use it....

ashfaq_haseeb — Wed, 20 Aug 2014 10:23:57 GMT

Hi,

have a look at below post too. One such example.

http://community.qlik.com/docs/DOC-1290

Regards

ASHFAQ

Re: What is scrambling & Why to Use it....

Wed, 20 Aug 2014 10:26:56 GMT

Hi Jagan,

If I am not wrong. Are the Scramble function is decrepting the value from the outsider?.

Thanks

Re: What is scrambling & Why to Use it....

jagan — Wed, 20 Aug 2014 10:44:52 GMT

We are encryting the values from outsiders.

Regards,

Jagan.

Re: What is scrambling & Why to Use it....

Wed, 20 Aug 2014 11:00:05 GMT

Hi Jagan,

Sorry, It is slip of my words. I mean encryting only i.e. masking the value.

Regard

Re: What is scrambling & Why to Use it....

jagan — Wed, 20 Aug 2014 14:16:29 GMT

Yes. It will encrypt into some other values.

Regards,

Jagan.

Re: What is scrambling & Why to Use it....

sgg_gaikwad — Thu, 21 Aug 2014 05:50:07 GMT

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

Re: What is scrambling & Why to Use it....

jagan — Thu, 21 Aug 2014 05:59:53 GMT

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.

Re: What is scrambling & Why to Use it....

sgg_gaikwad — Thu, 21 Aug 2014 06:11:16 GMT

Hi Jagan,

1) Yesterday i got one example of Scrambling through Mapping but i was little bit confuse about it, do you have any idea for the same..?

2) When We Reload our application all the Scrambling will get removed is there any way to avoid this...?

Regards,

Swapnil

Re: What is scrambling & Why to Use it....

jagan — Thu, 21 Aug 2014 06:33:02 GMT

Hi,

Using Mapping also you can scramble the data, it is also other method for example changing customer A to B etc.

If you do scrambling in Document Properties then when you reload scrambling will not be in place again you need to scramble the data, but if you do it using Mapping or Hash functions then you do not face this issue, because while loading itself we are doing the scrambling.

Hope this helps you.

Regards,

Jagan.

Re: What is scrambling & Why to Use it....

sgg_gaikwad — Thu, 21 Aug 2014 10:16:29 GMT

Hi Jagan,

Thanks for sharing valuable knowledge

Regards,

Swapnil