Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello friends,
am using excel file for section access and columns are like below
ACCESS | NTNAME | PLANTCODE | USER | SH14 | SH11 | SH12 | SH13 | SH15 |
ADMIN | DOMAINNAME\ADMINISTRATOR | <ALL> | DOMAINNAME\ADMINISTRATOR | 1 | 1 | 1 | 0 | 1 |
USER | DOMAINNAME\SACHIN | 1100 | DOMAINNAME\SACHIN | 1 | 1 | 0 | 0 | 1 |
USER | DOMAINNAME\RAHUL | 1200 | DOMAINNAME\RAHUL | 1 | 1 | 0 | 0 | 0 |
USER | DOMAINNAME\RAHUL | 1300 | DOMAINNAME\RAHUL | 1 | 1 | 0 | 0 | 0 |
below code i have used in application:
SECTION Access;
Access:
LOAD Upper (ACCESS) as ACCESS,
Upper (NTNAME) as NTNAME,
Upper (PLANTCODE) as PLANTCODE,
Upper (USER) as USER
FROM
[$(vSectionAccess)SectionAccess - Operations.xlsx]
(ooxml, embedded labels, table is Sheet1);
SECTION Application;
Sheetlevel:
LOAD Upper (USER) as USER,
SH14,
SH11,
SH13,
SH12,
SH15
FROM
[$(vSectionAccess)SectionAccess .xlsx]
(ooxml, embedded labels, table is Sheet1);
and added condition in sheet properties:
=USER = Only({<SH11={1}>} USER)
Unfortunately this is not working as expected. PLANCODE Wise access restriction is working but sheet level access is not working. all sheets are visible to all users. please help to restrict sheet level access.
Thanks in advance
HI @pk
Based on ur sample, all user has sheet 11 access. so yes, it will display for all users.
Only({<SH11={1}>} USER)
Many examples are available in Community. For basic, please refer below. Hope it helps
https://community.qlik.com/t5/QlikView-Documents/Type-of-Security/ta-p/1490510
Thanks for revert. All users have access of SH11 but in the sample data there are multiple sheets which are also visible to all user which is incorrect.
HI @pk
Can you provide the sample file and excel sheet to verify
Hi,
try this condition for sheet visibility: =Only(SH11)
@MayilVahanan refer attached files
Hi,
the formula i provided returns 1 or 0 and it should work if placed as a sheet visibility condition.
If your reduction on PLANTCODE works perfectly and the USER is associated with respective NTNAME then sheet visibility should work too.