topic Role Based Accessibility for QVW sheets in QlikView

Role Based Accessibility for QVW sheets

Wed, 28 Aug 2013 06:07:14 GMT

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

Re: Role Based Accessibility for QVW sheets

tresB — Wed, 28 Aug 2013 06:19:07 GMT

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

Re: Role Based Accessibility for QVW sheets

Wed, 28 Aug 2013 12:16:38 GMT

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