How to get the corresponding value based on the login user used in Section Access?

[#1]

Hi,

I have a requirement s follows...

Need to filter data based on the login user. How to get value corresponding to the login user after successful login.

USERID	PASSWORD	COUNTRY
A	123	Ind
B	123	UK
C	123	USA
D	123	Jap

Thanks in Advance,

Sohm.

[#2]

Just wanted to continue which I forgot to include...

If Login user is A, then my requirement is to use the corresponding country associated in the SQL (i.e. Ind user if user is A OR USA if user is C and so...on depending on the login user).

[#3]

Hi,

If you are login with the NTName as a userID You can use the OSUser() functionality

[kalyandg]

hi,

Go to Document Properties, Opening tab, kindly check(tick) the Initial Data Reduction Based on Section Access.

Save the document and close, later open and login with any user, and it will show corresponding values of the particular user who have been logged into the document.

Thanks,

Kalyan

[#5]

I am just clearing my question again...

I have a query to fetch data as...

Select * from transaction_data

Where Country = $Country

I want to set Country corresponding to UserID (that is logged in) in the variable in above query.

So, how do I get the value?

my requirement is as... If UserId is A (if User logged in as A) then my SQL query should be like as follows...

Select * from transaction_data

Where Country = 'Ind'

Since country 'Ind' is associated with UserID 'A'.

Thanks,

Sohm.

[#6 · Accepted solution]

I got the solution,

below is the useful link.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization