Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Section Access - Help

Hi,

I am trying to do Section Access but does not seem to work? Below is the script I am using that looks at a excel spreadsheet, does anything within the document needs to be changed i.e. Documetnt Properties?

SECTION ACCESS;
Security:
LOAD [ACCESS],
NTNAME,
LEVEL
FROM
[$(vSectionAccessPath)\AccessControl.xlsx]
(ooxml, embedded labels, table is ACCESS);


SECTION APPLICATION;

STAR IS *;

Reduction:
LOAD LEVEL,
[Clearance Level]
FROM
[$(vSectionAccessPath)\AccessControl.xlsx]
(ooxml, embedded labels, table is LEVEL);

1 Solution

Accepted Solutions
danielrozental
Master II
Master II

You need to set the following option in the Document Properties, Opening Tab

"Initial Data Reduction Based on Section Access"

View solution in original post

2 Replies
danielrozental
Master II
Master II

You need to set the following option in the Document Properties, Opening Tab

"Initial Data Reduction Based on Section Access"

ivandrago
Creator II
Creator II
Author

nice one