topic Re: How to hide sheet from users? in QlikView

How to hide sheet from users?

chiranjivdas — Fri, 03 Oct 2014 16:04:59 GMT

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,

Re: How to hide sheet from users?

JonnyPoole — Fri, 03 Oct 2014 16:09:18 GMT

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.

Re: How to hide sheet from users?

Anonymous — Fri, 03 Oct 2014 16:12:38 GMT

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

Re: How to hide sheet from users?

maxgro — Fri, 03 Oct 2014 17:52:48 GMT

small example with USERID

Re: How to hide sheet from users?

Fri, 03 Oct 2014 18:00:08 GMT

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.

Re: How to hide sheet from users?

Fri, 03 Oct 2014 18:00:45 GMT

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

];