Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
hrobertsonqv
Contributor II
Contributor II

Section Access not working as expected

I have added the following Section Access under Hidden Script ( I have removed filenames here), but after reload, all users can see all datasets.  This has worked before in another QV document but not this time.

Under Settings > Document Properties > Server, the 'Filter AccessPoint Document List Based on Section Access' is also ticked.

Is there something else I need to do to get this section access to work correctly?

//Security

SECTION ACCESS;

LOAD NTNAME,
     [ACCESS]
FROM
[\\XXXXXXXXXXXX.xls]
(biff, embedded labels, table is [Step 1$]);

SECTION APPLICATION;

Star is *;


LOAD NTNAME,
     [Business Unit]
FROM
[\\XXXXXXXXXXX.xls]
(biff, embedded labels, table is [Step 2$]);

1 Solution

Accepted Solutions
rajni_batra
Specialist
Specialist

Document properties> Opening Sheet > Initial data reduction based on section access(check this option)

Hope this helps!!!

View solution in original post

6 Replies
rajni_batra
Specialist
Specialist

Document properties> Opening Sheet > Initial data reduction based on section access(check this option)

Hope this helps!!!

hrobertsonqv
Contributor II
Contributor II
Author

Many thanks - that has done the trick!!

hrobertsonqv
Contributor II
Contributor II
Author

Many thanks - that has done the trick!!

hrobertsonqv
Contributor II
Contributor II
Author

Many thanks - that has done the trick!!

hrobertsonqv
Contributor II
Contributor II
Author

Many thansk for your prompt response

rajni_batra
Specialist
Specialist

most welcome...