Error while implementing section access in QLIKSENSE

[nikhilgarg]

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?

[jwjackso]

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 · Accepted solution]

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]

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]

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]

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]

Hey Paul,

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