topic Section Access not working as expected in QlikView

Section Access not working as expected

hrobertsonqv — Wed, 08 Aug 2012 09:41:52 GMT

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$]);

Re: Section Access not working as expected

rajni_batra — Wed, 08 Aug 2012 10:07:06 GMT

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

Hope this helps!!!

Re: Section Access not working as expected

hrobertsonqv — Wed, 08 Aug 2012 10:12:12 GMT

Many thanks - that has done the trick!!

Re: Section Access not working as expected

hrobertsonqv — Wed, 08 Aug 2012 10:12:21 GMT

Many thanks - that has done the trick!!

Re: Section Access not working as expected

hrobertsonqv — Wed, 08 Aug 2012 10:19:30 GMT

Many thanks - that has done the trick!!

Re: Section Access not working as expected

hrobertsonqv — Wed, 08 Aug 2012 10:20:00 GMT

Many thansk for your prompt response

Re: Section Access not working as expected

rajni_batra — Wed, 08 Aug 2012 10:33:59 GMT

most welcome...