Re: Access only a particular sheet - Qlik Community

Report Inappropriate Content · ‎2015-09-22

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?

stigchel · ‎2015-09-22

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'

Anonymous · ‎2015-09-22

Hi!

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

Regards

Report Inappropriate Content · ‎2016-01-21

Thanks a lot.

How to add multiple users? Please suggest me.

Anonymous · ‎2016-01-21

You can load a table with Users and ID Sheets

like

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.

Anonymous · ‎2016-01-21

Try it:

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

OSUser() ='OSUser()\User'

Regards.