Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

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
Master
Master

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.

View solution in original post

6 Replies
jwjackso
Specialist III
Specialist III

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
Master
Master

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
Partner - Champion
Partner - Champion

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
Specialist II
Specialist II
Author

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
Master
Master

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
Specialist II
Specialist II
Author

Hey Paul,

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