How to hide sheet from users?

[chiranjivdas]

I have two sheets - Sheet A & Sheet B.

I want to make Sheet A visible to John. His network logon is xyz\johns but I do not want him to see Sheet B.

Similarly, I want to make Sheet B visible to Sally. Her network logon is xyz\sallyd and I do not want her to see Sheet A.

Thanks,

CD

[JonnyPoole]

You can leverage these system functions in the show/hide condition to hide to certain users.  If you are using section access that can yield groups or users which can be associated to other field types to be used in condtions too..

OSuser( )

Returns a string containing the name of the current user as returned by the operating system.

QVuser( )

Returns a string containing the name of the current QlikView user as entered in a section access.

[Anonymous]

Hi!

You can create a file that contains the users that can't see sheet A, and load that file (or make a load inline). After that, in your sheet Contitional, you can do a condition with the users from the file.

Something like this:

[Users]:

LOAD * INLINE [

    Users

    sallyd

];

And in the Sheet Contitional:

=Not WildMatch(Concat(Users),'*' & PurgeChar(OSUser(),'xyz\') & '*')  > 0

Regards,

Gabriel

[maxgro]

small example with USERID

[#5]

Hi,

Try this:

Sheet Properties-->Show sheet- select conditional and add the below  condition.

WildMatch(Upper(OSUser()),'xyz\johns' ) > 0.

So that the particular sheet can be visible to john only.

Hope this will help you

Thanks,

Shekar.

[#6]

Hi,

You can even go for section access in the appln as below

I. Create Section Access

SECTION ACCESS;

LOAD * INLINE [

USERID,PASSWORD, ACCESS

ADMIN,123, ADMIN

USER1,123,USER

USER2,125,USER

];

SECTION APPLICATION;

LOAD * INLINE [

USERID,SHEETID

USER1,SH01

USER2,SH02

];