Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

agarciaguillen
New Contributor II

Qs - Section Access - Access Denied

Hello everyone,

Trying to use Section Access in my project i found a problem what i can't solve alone.

When i apply Section Access ( Doesn't matters if is to a USER or ADMIN ), after recharge the app, the user recieve an "Access Denied" to the App.

I follow all of tutorials in QS Wiki, and my own developer book but still show me this message.

Actually i use section access from Excel with this script:

section access;

DATA:

LOAD

    "ACCESS",

    "USERID",

    "GROUP",

    "ORGANIZACIÓN VENTA",

    "ZONA DE VENTA",

    "TIPO MATERIAL",

    "SUBTIPO MATERIAL",

    "NOMBRE JV",

    "VERSIÓN FCST",

    "RAMO TIPO"

FROM [lib://DEV_APPS_SALES_CFG/SECTION_ACCESS_TABLE.xlsx]

(ooxml, embedded labels, table is Hoja1);

Section Application;

and inside the excel i have :

section access.PNG

The version of my platform is:

version de qlik sense.png

My questions are:

  • I place this script at the total begining of the app. Does i need to put this script after something ?

  • I need enable some configuration in QMC to use Section Access ?

  • I need place all field than i have in my data model to use Section Access ?
3 Replies
zhadrakas
Valued Contributor

Re: Qs - Section Access - Access Denied

Hi Alvaro,

1) there is no ADMIN row in your Section Access Table. You need at least one.

2) try upper(USER_ID) to get everything in Uppercase

to your questions:

  • I place this script at the total begining of the app. Does i need to put this script after something ?
    • thats ok. In Qlikview there was a Hidden Script where you need to put your Section Access code. I dont know if that is the case for Sense too.

  • I need enable some configuration in QMC to use Section Access ?
    • Your Script should work.if your usernames are AD names, make sure that the username is used with domain prefix and this domain is added as "User directory connector" in QMC.

regards

tim

Not applicable

Re: Qs - Section Access - Access Denied

Hi Alvaro,

just change USERID to Upper(USERID) as USERID, in Section Access, the value of USERID need be upper case.

Regards,

Nina

umashankar_ts
New Contributor III

Re: Qs - Section Access - Access Denied

Section access once granted should always be followed by a reload of the Qvw. The changes will not be update until the reload is successfully completed. Make sure the reload is completed before you check the access after adding user to section access.

Community Browser