Role Based Accessibility for QVW sheets

[#1]

Hi Experts,

We need to build two sheets. The one sheet is available only to the Managers where as other sheet is available to the Managers and Sales Force. How Can I achieve this Role Based Accessibility ONLINE ?

Kindly Help.

Regards,

Kumar Gauraw

[tresesco]

Use conditional show for the sheet. General tab->Show Sheet-> Choose 'Conditional'. Now you have to write expression something like :

Role ='Manager'   // assuming that the users are mapped to a Field called 'Role' (in section acees) which has values like 'Manager', 'Sales force'

Or,

You can use use Osuser() function based on your user access authn/authrz method. I guess the earlier one is more effective.

You might want to have look here

[#3]

Thanx for Reply Tresesco..........

This one way to achieve the purpose but can we use QlikView Server (QMC) to solve this problem statement.

The Users we can pick from Active Directory of QlikView Publisher (The same which is used for providing access to Access Point).

Since I do not want to hard code the users.

Thanx

Gauraw