Hide Sheets depending on user

[salto]

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.

[#2 · Accepted solution]

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

[salto]

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

Regards.

[#4]

Hi Salto,

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

Thanks,

[salto]

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.

[#6]

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 ?