topic Hide Sheets depending on user in QlikView

Hide Sheets depending on user

salto — Mon, 03 May 2010 17:29:24 GMT

Hello,

I am trying to hide some sheets depending on the GROUP the user belongs to.

I am defining the group in an Excel file that I am loading in the hidden script:

Section Access;
Directory;
LOAD [ACCESS],
NTNAME,
[GROUP]
FROM IKLIST.xls (biff, embedded labels, table is Hoja1$);

Load * INLINE [
GROUP, OMIT
WORK, NAME
];

Section Application;
STAR IS *;

///* Limit Sheets/Tabs */
SheetPermissions:
LOAD [GROUP],
DASHBOARD,
SH15,
SH08,
FROM SheetPermissions.xls (biff, embedded labels, table is Hoja1$);

Group has the possible values of ADMIN, FULL or WORK in the IKLIST.xls, for every possible user.

The SheetPermission.xls file has this look:

GROUP	SH08	SH15
WORK	0	1
FULL	0	1
ADMIN	1	1

I thought this was enough to hide the SH08 sheet for WORK and FULL groups. But still SH08 appears. This method worked for hiding some objects in this same file. Can I hide the sheets this way? Or should I go through the "Conditional" property in the sheet?

Many thanks in advance.

Hide Sheets depending on user

Mon, 03 May 2010 23:57:31 GMT

Hi SALTO,

For what it is worth I have always use the conditional property on the sheet simply because it is easy to set up.

Rod

Hide Sheets depending on user

salto — Thu, 06 May 2010 11:40:48 GMT

Thank you, I did it that way and works like a charm.

Regards.

Hide Sheets depending on user

Thu, 17 Feb 2011 14:57:44 GMT

Hi Salto,

Could you pls let me know how to implement in conditional properties as I am not aware of this.

Thanks,

Hide Sheets depending on user

salto — Thu, 17 Feb 2011 15:31:34 GMT

Hello Tims,

This is what I did: in the Sheet Properties -> General -> Show Sheet -> Conditional option, I choose which users can see the sheet using the mixmatch and osuser commands:

=mixmatch(osuser(),'DOMAIN\username_1',...,'DOMAIN\username_n')

As far as I know, it is not possible (in Qlik) to use a command that extracts the Domain Group the user belongs to. It would shorten my conditional properties command!

Kind regards.

Hide Sheets depending on user

Thu, 08 Sep 2011 21:26:12 GMT

Hi rjager,

I am a new user to qlikview and tried implementing sheet security using the conditional option. I did use groups where each AD user (active directory) was associated with a group in a spreadsheet. The spreadsheets were part of the script under edit script. Then I put conditional logic naming which groups could have the sheets in each sheet. It worked fine as far as keeping certain users from seeing certain sheets. But ... our presentation response time was significantly degraded. do you have any ideas on how to keep it from affecting the response time ?