topic Re: Section Access by APP and User in QlikView

Section Access by APP and User

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I have a doubt with Section Access. ¿It's possible to include a filter of Document Name to establish permission in Access Point?

I have one xls to set permission for each app and would like to use only one XLS for all apps.

I'm tried to do this, but doesn't work, ¿any help?

SET V_APP = 'DocumentName()';

SECTION Access;

ACCESO:

LOAD ACCESS,

upper(Usuario) as Usuario,

upper(APP)

FROM

(ooxml, embedded labels, table is ACCESO)

Where APP =upper($(V_APP));

Re: Section Access by APP and User

mrossoit — Wed, 25 Mar 2015 11:44:00 GMT

You need also password field in your xlsx.

Try:

SET V_APP = upper(DocumentName());

SECTION Access;

ACCESO:

LOAD ACCESS,

upper(Usuario) as USERID,

upper(Password) as PASSWORD,

upper(APP)

FROM

(ooxml, embedded labels, table is ACCESO)

Where APP ='$(V_APP)';

Re: Section Access by APP and User

Wed, 25 Mar 2015 12:12:54 GMT

Hi Massimiliano, the access is fine. We use a local domain controller to set a password and dont need load a password field too.

Just need to link "DocumentName()" with "NamedUser()" for establish Section Access in Script, i think that is posible with publisher but not sure in Script.

Thanks for response Massimiliano

Re: Section Access by APP and User

mrossoit — Wed, 25 Mar 2015 12:27:39 GMT

The correct way to manage accesses to your Access Point pass through CALs but in your question you seem to want a second level of control.

If you want to use section access at all costs I'm pretty sure that your table ACCESO must contains at least ACCESS, USERID and PASSWORD fields with upper values into them.

If your password list resides in another repository you should join fields from your xlsx to passwords using username as link.