topic Re: Section Access, fiter per sheet in QlikView

Section Access, fiter per sheet

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

Hello everyone

I want to block some sheets per user, and now I only did the Section Access:

SECTION Access;

LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, password
USER, USER, password
];

SECTION Application;

Someone can help me to filter the acces per user in each sheet?

Thanks!!

Re: Section Access, fiter per sheet

Vegar — Fri, 31 Jan 2020 19:39:45 GMT

Section access is primarily designed for reducing/slicing data not visual elements. So you can't remove elements from the application based on section access, but you can hide elements. Hidden elements will remain hidden for users in the accespoint, but if they gain access to the qvw there are ways to display hidden elements in the desktop.

Try the SA below and then define a show condition on your Dashboard sheet that the SHEET value 'DASHBOARD' needs to be available in order to display, do the same for your analysis sheet, etc...

SECTION Access;

LOAD ACCESS, USERID, PASSWORD,

subfield(SHEETS, '|') as SHEET

INLINE [
ACCESS, USERID, PASSWORD, SHEETS
ADMIN, ADMIN, password, DASHBOARD|ANALYSIS
USER, USER, password, DASHBOARD
];

SECTION Application;

SHEETS:

LOAD * INLINE [

SHEET

DASHBOARD

ANALYSIS

];

LOAD ...the rest of your data model.

Re: Section Access, fiter per sheet

Brett_Bleess — Mon, 24 Feb 2020 22:34:05 GMT

One additional link for you that might be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

There are a few extra links at the bottom of that post related to dynamic reduction, which is what you are looking to do potentially, but another way may be to just try using the Conditional Show option in the Sheet Properties and use either the OSUser() or QVUser() depending upon which Section Access you are doing may work too and be a bit more simple for you.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/SystemFunctions/system-functions.htm

Regards,
Brett