topic Re: Cannot make section access work in QlikView

Cannot make section access work

Mon, 26 Jan 2026 18:19:17 GMT

Hello Everyone,

I try to apply section access to sheet level. Please look on attached QVW. The code does not work if I load section access from excel.

The code will work if I load inline but cannot publish to upfront.

Can anybody help me on this issue?

Thank you very much in advance.

Best regards,

Dust

Re: Cannot make section access work

maxgro — Tue, 17 Nov 2015 17:39:25 GMT

I'm not able to open the doc, because of section access (access denied)

Re: Cannot make section access work

Tue, 17 Nov 2015 19:37:59 GMT

Maxgo,

Please see attached code. It's using NTName and will block out access. I comment this code. Un-comment and reload to see.

Let me know if you have any idea.

Best regards,

Dust

Re: Cannot make section access work

maxgro — Tue, 17 Nov 2015 20:09:23 GMT

I used this, no upper and I replaced the field USERID with FIELD (in excel too)

Also in menù --> settimgs --> document properties --> opening I checked Initial data reduction..... and Strict Exclusion

Section Access;

SECURITY:

LOAD ACCESS,

NTNAME,

FIELD

FROM

[TermSheetAccess.xlsx]

(ooxml, embedded labels, table is Access);

Section Application;

SheetAccessMatrix:

LOAD upper(FIELD) as FIELD ,

[SHEET1],

[SHEET2]

FROM

[TermSheetAccess.xlsx]

(ooxml, embedded labels, table is Page);

Re: Cannot make section access work

Tue, 17 Nov 2015 20:53:29 GMT

Thank you - Maxgo.

Can you upload this qvw again. I cannot open this file.

Appreciate.

Re: Cannot make section access work

Tue, 17 Nov 2015 21:15:31 GMT

Hi Maxgro,

Your code is working but I cannot publish this testing qvw to upfront. I got this error:

(2015-11-17 16:06:52) Error: The document failed to open. Bad Username and password is the most likely cause of this problem.

Do you think where I need setup this username and password? Currently, I set myself as admin but I cannot publish.

Thank you very much.

Dust

Re: Cannot make section access work

Wed, 18 Nov 2015 01:06:33 GMT

I add program domain admin name to it and it can publish now.

Thank you very much -- Maxgro.