Section acess hide column data

[Anonymous]

I want to apply section access for the following scenario

I have following data

User,Country,dob

U1,USA,01/01/2017

U2,UK,20/01/2017

U3,SPAIN,21/02/2017

I need to display data as

When U1 logs in then following should be displayed

User,Country,dob

U1,USA,01/01/2017

U2,UK,***

U3,SPAIN,***

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,20/01/2017

U3,SPAIN,***

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,***

U3,SPAIN,***

[Anonymous]

Thanks for reply.

I tried using osuser(), it works perfect on local machine, but when accessed from access point it gives some random value.

Please suggest.

[eduardo_dimperio]

Amar,

OSUser() get the NT user, try this subfield(OSUser(), '\', 2)  and check if correspond to the user logged on NT

[Anonymous]

I have already checked subfield(OSUser(), '\', 2).

It gives random value.

[Anil_Babu_Samineni]

Have you tried Massimo solution?

[Anil_Babu_Samineni]

I assume, QvUser() instead OSUSER()

[eduardo_dimperio]

Hi Amar,

I agree with Anil. Try QvUser(), i read this post about it and this solution worked.

=QVuser() vriable doesn't return a username | Qlik Community

Using NTName in section access | Qlik Community

OSUser and NTNAME in Section Access