Showing masked data and real data

[gauthamchilled]

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?

[gauthamchilled]

Bump.

Any help plz?

[marcus_sommer]

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

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

- Marcus

[florentina_doga]

use section access

[Clever_Anjos]

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

[Digvijay_Singh]

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.

[gauthamchilled]

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?