topic Re: MASKED DATA CALCULATION in QlikView

MASKED DATA CALCULATION

aj0031724 — Fri, 24 Jul 2015 13:28:18 GMT

Team,

There is a requirement to show masked data when user doe snot have the valid priviliges instead of actual data.

Maksing is done with asterisk "*'' deending on number of digits to masked required by user.

now the real problem comes when I want to show count of x based on masked data .

Here count comes correct for actual data as all are unique but count gets wrong when done by Masked data as because it is getting clubbed together with similar pattern of data.

For example:

actual data ---count of x is 8

1) 12345

2)12389

3)12378

Masked data representation of above is where last 2 digits have been masked:

1) 123**

2)123**

3)123**

Now as here masked data become same for all actal data here count comes in TOTAL rather than individual I am getting only one row with 123** with count of x as 24(8+8+8). which is wrong.

we are using straight table .

Please let me know how can I show the correct count for masked data as well.

Re: MASKED DATA CALCULATION

marcus_sommer — Fri, 24 Jul 2015 13:36:13 GMT

You could load this field twice - one with your masked logic and one with autonumber(OriginField) as FieldForCounter. But are the data real confidental you should use section access.

- Marcus

Re: MASKED DATA CALCULATION

MarcoWedel — Fri, 24 Jul 2015 23:07:28 GMT

Hi,

one solution could be also:

table1:
LOAD Ceil(Rand()*200)+12300 as [actual data]
AutoGenerate 1000;

Left Join
LOAD [actual data],
    Dual(Left([actual data],Len([actual data])-2)&'**',AutoNumber([actual data])) as [masked data]
Resident table1
Order By [actual data];

hope this helps

regards

Marco

Re: MASKED DATA CALCULATION

aj0031724 — Mon, 27 Jul 2015 10:52:08 GMT

Thanks Marcus.

Re: MASKED DATA CALCULATION

aj0031724 — Mon, 27 Jul 2015 10:53:28 GMT

Thanks Marco ,I have implemented the logic and it worked.

Many thanks for the sample qvw and code logic.

Re: MASKED DATA CALCULATION

MarcoWedel — Mon, 27 Jul 2015 10:55:50 GMT

you're welcome

please close your thread by selecting a correct answer.

thanks

regards

Marco