topic Re: Section Access in QlikView

Section Access

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

Is there a way to setup the section access to filter data from a file and also hide tabs for select users at the same time.

Example:

I have a two salesman that can only see thier sales data on tabs (A &B) and i have a manager that can see both salesman data on tabs(A &B) and additional company sales information on tabs (C & D).

CODE:

Section Access;

Security:

LOAD ACCESS,

USERID,

PASSWORD,

SCCO,

SCSLSM,

SCLOC,

Upper(SCCO&'|'&SCSLSM&'|'&SCLOC) as %AUTHID,

SQL SELECT *

FROM [\\Data Library\Sales\SECURITY.qvd]

(qvd);

Section Application;

InvHeader:

LOAD IHINVN as InvoiceNumber,

IHTYPP as DBCR,

IHINYY,

IHORNO,

Date(Floor(Date#(IHIDAT, 'YYYYMMDD'))) as MasterDate,

IHCUNO as Customer,

NACOMP,

CTNAME,

IHINVN as Loc

Upper(NACOMP&'|'&CTNAME&'|'& applymap ('InvDet',IHINVN,'nomatch')) as AuthID

FROM [\\Data Library\Sales\SROISHB.qvd]

(qvd);

AuthBridgeTable:

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper(NACOMP&'|'& CTNAME&'|'&Loc) as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper(NACOMP&'|'&'<ANY>'&'|'&Loc) as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper(NACOMP&'|'&'<ANY>'&'|'&'<ANY>') as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper(NACOMP&'|'&CTNAME&'|'&'<ANY>') as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper('<ANY>'&'|'& CTNAME&'|'&Loc) as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper('<ANY>'&'|'& CTNAME&'|'&'<ANY>') as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper('<ANY>'&'|'&'<ANY>'&'|'&Loc) as %AUTHID Resident InvHeader;

Load Upper(NACOMP&'|'& CTNAME&'|'&Loc) as AuthID, Upper('<ANY>'&'|'&'<ANY>'&'|'&'<ANY>') as %AUTHID Resident InvHeader;

Thanks in advance,

Jim

Re: Section Access

its_anandrjs — Thu, 14 Sep 2017 12:20:59 GMT

You have required Object level section access

Check some of this

Various levels of security implementation using Section Access

https://community.qlik.com/docs/DOC-18522

Re: Section Access

jjking58 — Thu, 14 Sep 2017 14:50:50 GMT

Thanks for the different examples, but how do i code file level security and object level security in the same document?

Re: Section Access

Peter_Cammaert — Thu, 14 Sep 2017 15:06:21 GMT

That depends on how selective you want to be with your granting access to specific sheets. In theory, you create a sheet access table in Section Application and connect it to the same filter %AuthID that controls Data Reduction.

The Data Reduction for rows seems to be put in place already. Select a mechnism to manage Sheet-(& optionally object-)level access from the examples and attach it to your link field.

Re: Section Access

jjking58 — Thu, 14 Sep 2017 16:33:32 GMT

Thanks Anand & Peter

I took both suggestions and came up with the following which is working fine.

The code I originally posted stayed intact, but I added an additional field (SCTAB) to the table (Security) under the Section Access and populated with either a 1 or 2 for each user.

I then added the following under the Section Application

TabAccess:
LOAD * INLINE [
SCTAB, SH02, SH04, SH05, SH06, SH07
1, 1, 1, 1, 1, 1
2, 1, 1, 1, 0, 0
];

Finally I set a condition under Sheet Properties / General for each tab if (“Sheet ID=1,1,0)