Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

Error while implementing section access in QLIKSENSE

Hello ALL,

I have implemented Section Access in my QLIKSENSE Application. But it is giving me error "Access Denied".

I have written following script:

Section Access;

LOAD

    ACCESS,

    USERID,

    "PASSWORD",

    REGION

FROM [lib://Desktop (dsd_dsdadmin)/Section Access.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

LOAD

    USER,

    SALES,

    REGION

FROM [lib://Desktop (dsd_dsdadmin)/Section Access.xlsx]

(ooxml, embedded labels, table is Sheet2);

I ahve attached Scection Access file as well for our reference. Can anyone help me knowing what is missing?

1 Solution

Accepted Solutions
rittermd
Honored Contributor

Re: Error while implementing section access in QLIKSENSE

The user column has to contain the domain name/username just like it shows in the QMC.

If you are not on Enterprise then section access doesn't work in desktop.

6 Replies
jwjackso
Contributor III

Re: Error while implementing section access in QLIKSENSE

In Guldberg's article (Introduction to Section Access), he mentions that the "*" means access to the values listed, not all values.  Do you have access to region R1, R2, R3 or R4?

rittermd
Honored Contributor

Re: Error while implementing section access in QLIKSENSE

The user column has to contain the domain name/username just like it shows in the QMC.

If you are not on Enterprise then section access doesn't work in desktop.

agigliotti
Honored Contributor II

Re: Error while implementing section access in QLIKSENSE

let's try the below modified script:

Section Access;

SA:

LOAD

    ACCESS,

    USERID,

    PASSWORD,

    REGION as SA_REGION

FROM [lib://Desktop (dsd_dsdadmin)/Section Access.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

LOAD

    USERID,

    SA_REGION as REGION

Resident SA;

where REGION is the field name of your data model to make the data reduction on.

AND also

follow what rittermd‌ said about USERID that has to be in the format of userdirectory\username as you see on QMC.

i hope this helps.

nikhilgarg
Contributor III

Re: Error while implementing section access in QLIKSENSE

Hey Mark,

Tha ks it is working fine now after using domain name. Just want to know

why section access does not work in Qliksense personal edition?

rittermd
Honored Contributor

Re: Error while implementing section access in QLIKSENSE

That is one of many features that is not offered in the desktop version.  Normally section access would only come into play if you were creating dashboards for a large group of users.  If you are doing that then you really need Enterprise so that they can access the dashboard and you can reload on a schedule, etc. 

Desktop is really intended for personal use.  Not to say that you can't do more than that.  But you can't do everything you could with Enterprise.

If you don't mind mark my response as correct.  Thanks

nikhilgarg
Contributor III

Re: Error while implementing section access in QLIKSENSE

Hey Paul,

Thanks but i have asked IT team to open the ports 4244, 4248, 443 for public IP. Lets see if this works.

Community Browser