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: 
Not applicable

Cannot make section access work

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

6 Replies
maxgro
MVP
MVP

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

Not applicable
Author

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

maxgro
MVP
MVP

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

Not applicable
Author

Thank you - Maxgo.

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

Appreciate.

Not applicable
Author

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

Not applicable
Author

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

Thank you very much -- Maxgro.