Question about Windows security

[#1]

Hi All,

I go into this issue:

I have two tables:

A:

Country Quantity

Brazil 1

USA 2

B:

Country WindowsUser

Brazil domain\Jack

If the current user is Jack, he only can see the record "Brazil 1" in table A. How can I achieve it? And how can I get who is the current user, does QV have some functions to support this?

Many thanks.

Isaac

[#2]

You need to use a feature called "section access". You can look in QlikView Help, the QlikView User Manual, and the forums for many examples on how to set this up.

Gary

[#3]

I think you can do one of the following:

1. Have it filtered on the document using user name -- there is a function in QV called OSUser()

2. Have publisher generate qvw for each user filtering by user -- you can refer QV Manual to do this.

I hope this helps.

[#4]

Hi pinongs,

Thanks a lot.

Isaac Li