topic Re: Some idea for data masking/changing in the presentation level? in QlikView

Some idea for data masking/changing in the presentation level?

Tue, 30 Jul 2013 13:33:10 GMT

Hi,

I have a collumn with ID's (numbers). When I present those in the table I need to somehow make them either looked mask'ed or put some whatever random text/color/numbers/something instead.

and can it be done on the presentation level ?

(not in the script level).

any idea how to do that?

Thanks in advance.

Re: Some idea for data masking/changing in the presentation level?

Qlik__Vinodh — Tue, 30 Jul 2013 13:39:53 GMT

yes, it is possible in presentation level

Re: Some idea for data masking/changing in the presentation level?

Tue, 30 Jul 2013 13:51:15 GMT

ok, how?

Re: Some idea for data masking/changing in the presentation level?

Qlik__Vinodh — Tue, 30 Jul 2013 13:58:37 GMT

can u elobrate detaily, what u require with Example

Re: Some idea for data masking/changing in the presentation level?

shree909 — Tue, 30 Jul 2013 14:22:15 GMT

Hi if u want to change the names or mask in the charts or tables.

whenever u add a dimenion or expression,u get as "+" try to expand that

u have options for changing the color or text, background color ,change it to either bold,italic,underline.

that can be done,if u are looking for something different post a sample file and what exactly u want to change..

Re: Some idea for data masking/changing in the presentation level?

Tue, 30 Jul 2013 16:41:06 GMT

ok.

I have a collumn with IDs (numbers):

i.e.

Collumn #1

1111

1112

1113

1212

1313

1143

when I need to present that in the table. I need to mask those IDs. replaced with anythihng there instead.

so it would look something like:

Collumn #1

asdff

32232

****1

Re: Some idea for data masking/changing in the presentation level?

Qlik__Vinodh — Wed, 31 Jul 2013 07:03:43 GMT

did this have any conditions on that column ? or entire column has to be mask ? or certain ID need to mask?

Re: Some idea for data masking/changing in the presentation level?

jagan — Wed, 31 Jul 2013 07:27:14 GMT

Hi,

Scramble the content by using the Document ->Properties -> Scrambling -> Select the Field and press Scramble button.

This replaces the actuals with some other values.

Hope this helps you.

Regards,

Jagan.

Re: Some idea for data masking/changing in the presentation level?

Wed, 31 Jul 2013 07:45:52 GMT

jagan mohan below told me what i was looking after :s

However if you have another way I am always curuise.

there is no conditions

entire column has to be masked (but how would you do it if it was just certain ids?)

Re: Some idea for data masking/changing in the presentation level?

Wed, 31 Jul 2013 07:46:20 GMT

thanks! thats exactly what i was looking

Re: Some idea for data masking/changing in the presentation level?

jagan — Wed, 31 Jul 2013 08:07:30 GMT

Hi,

If you want to replace values for certain IDs then you need to use if or Match() and then you need to use the Rand() to generate different values.

Hope this helps you.

Regards,

jagan.