Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is Section Access and Section Application?

Hi all,

I have the following script but I am not entirely show what function Section Access and Section Application statements perform. Can anybody help break it down simply what it does please?

//Section Access;

//Access01:

//LOAD * INLINE [

//    ACCESS, USERID, PASSWORD

//    ADMIN, ADMIN, ADMIN

//    USER, USER, USER

//];

//Section Application;

Section Access;

Access01:

LOAD USERID,

     ACCESS,

     SP

FROM

[Datasources\SalesSecurity.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Section Application;

Access_Application:

LOAD

  Upper(SP) as SP,

     [SalesPerson]

FROM

[Datasources\SalesInitials.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

3 Replies
swuehl
MVP
MVP

This should be a good introduction to section access / application:

Introduction to Section Access

its_anandrjs
Champion III
Champion III

Or this will also help you for understanding what is section access

QlikView Section Access Examples

Introduction to Section Access