Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
Returns a string containing the name of the current user as returned by the operating system.
Returns a string containing the name of the current QlikView user as entered in a section access.
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
small example with USERID
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.
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
];