Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,***
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.
Amar,
OSUser() get the NT user, try this subfield(OSUser(), '\', 2) and check if correspond to the user logged on NT
I have already checked subfield(OSUser(), '\', 2).
It gives random value.
Have you tried Massimo solution?
I assume, QvUser() instead OSUSER()
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