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: 
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...