topic Re: Showing masked data and real data in QlikView

Showing masked data and real data

gauthamchilled — Thu, 09 Jun 2016 09:18:13 GMT

Hi,

I have a straight table or pivot table in my dashboard where i am showing employee details. say for example in below format

EmployeeName Salary Bonus JoinDate Clientname

ABC 5000 1000 12021985 JPMC

Here ABC is the masked kind of name getting it from our DB. Now for particular country users they want to see their actual name instead of this masked name, They have their own db mapped with this mask name.

How can i show real name only for their countries and masked name if some other coutry user see the data.

dashboard sectionaccess with country level, however global user will see all country data. We are not going to show real name of the employee to any one except the particual country users.

Can anyone give idea?

Re: Masking

gauthamchilled — Fri, 10 Jun 2016 01:19:40 GMT

Bump.

Any help plz?

Re: Showing masked data and real data

marcus_sommer — Fri, 10 Jun 2016 13:13:26 GMT

I think you need to combine Section Access with something like this:

if(osuser() = 'x', [Real Name], [Masked Name])

- Marcus

Re: Showing masked data and real data

florentina_doga — Fri, 10 Jun 2016 13:19:00 GMT

use section access

Re: Showing masked data and real data

Clever_Anjos — Fri, 10 Jun 2016 13:22:34 GMT

There´s on special feature in Section Access, where you can indicate a column that will be ommited

LOAD * INLINE [

ACCESS, NTNAME, TENANT, OMMIT

ADMIN, CLK\SWB_CLEVER,*,

USER, CLK\QLIKVIEWSERVICE, *,REALNAME

]

With this setup the user CLK\QLIKVIEWSERVICE won´t see the REALNAME field and others will see that field

Re: Showing masked data and real data

Digvijay_Singh — Fri, 10 Jun 2016 13:26:33 GMT

I think somehow you need to maintain a flag variable having two values identifying the type of user, based on type of country user this flag needs to be set and checked in frontend to understand weather the real name to be shown or masked name to be shown.

Re: Showing masked data and real data

gauthamchilled — Thu, 14 Jul 2016 02:54:11 GMT

Thanks for all your comments, I can do it using a flag control from section access. The problem is i as a developer not going to have to access to the actual employee names of particular country due to safe harbour law.

Is it still possible that only the user in that country x only see their actual names?