topic Re: Access only a particular sheet in QlikView

Access only a particular sheet

Tue, 22 Sep 2015 13:39:57 GMT

How can a user directly access one particular sheet? that means how we can give the access only to that particular sheet to a particular user?

Re: Access only a particular sheet

stigchel — Tue, 22 Sep 2015 14:03:52 GMT

You could use the conditional show of the sheet(s) to hide other sheets in combination with the OSUser() function. Sheet properties, conditional show expression e.g.

=OSUser()<>'Domain\User'

Also:

Document properties->Security tab-> Uncheck 'Show All Sheets and Objects'

Re: Access only a particular sheet

Anonymous — Tue, 22 Sep 2015 14:19:22 GMT

Hi!

Sheet Properties->General-> Show Sheet -> Select Conditional

Regards

Re: Access only a particular sheet

Thu, 21 Jan 2016 15:49:36 GMT

Thanks a lot.

How to add multiple users? Please suggest me.

Re: Access only a particular sheet

Anonymous — Thu, 21 Jan 2016 16:21:20 GMT

You can load a table with Users and ID Sheets

User Sheet

User1 SH01

User2 SH02

User3 SH03

Then a trigger on open document with Activate Sheet (IDSheet)

Then Check the box Hide Tabrow in the Document propieties.

Re: Access only a particular sheet

Anonymous — Thu, 21 Jan 2016 18:05:34 GMT

Try it:

OSUser() ='OSUser()\User' or

OSUser() ='OSUser()\User'

Regards.