Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Highlighted
Not applicable

Section Access by APP and User

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));

Tags (2)
3 Replies
mrossoit
Contributor II

Re: Section Access by APP and User

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)';

Not applicable

Re: Section Access by APP and User

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

mrossoit
Contributor II

Re: Section Access by APP and User

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.