Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

salonipande27
New Contributor

what is section access with example?

Hi all,

Can anybody explain me section access with proper example??

4 Replies
oknotsen
Honored Contributor III

Re: what is section access with example?

Managing security with section access ‒ Qlik Sense

May you live in interesting times!
salonipande27
New Contributor

Re: what is section access with example?

thanks

rittermd
Honored Contributor

Re: what is section access with example?

Basically you are adding code at the start of your app that is identified as Section Access.  You are either loading an InLine table or accessing an external file that contains the Userid, type of access, and what you want to have them to see or exclude.

The syntax is very specific. 

The Qlik help file is useful.  But a real life example is always better.  At least for me.

This is loading the values to determine the user access to the data displayed in the app.

LOAD

    ACCESS,

    USERID,

    "BRANCH-ID"

FROM [lib://External_Data/SectionAccessUsernames.xlsm]

(ooxml, embedded labels, table is Access);

Then you include this line at the start of the script that generates the data for the app:

section application;

Hope that helps some.

salonipande27
New Contributor

Re: what is section access with example?

Thanks, Mark Ritter this is really very helpful but didn't get what is  "BRANCH-ID" in load statement. can you explain me??