Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

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
MVP
MVP

Re: Cannot make section access work

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

6 Replies
MVP
MVP

Re: Cannot make section access work

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

Not applicable

Re: Cannot make section access work

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

MVP
MVP

Re: Cannot make section access work

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

Re: Cannot make section access work

Thank you - Maxgo.

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

Appreciate.

Not applicable

Re: Cannot make section access work

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

Re: Cannot make section access work

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

Thank you very much -- Maxgro.

Community Browser