Section Access Issue

[alec1982]

Hi Guys,

I have a section access set on a qvw as follow:

Section Access;

Star is *;

LOAD ACCESS,

    UPPER(NTNAME) AS NTNAME,

     %PROJECT_MANAGER,

     %PROGRAM_MANAGER

FROM

[..\Excel Input\Security.xlsx]

(ooxml, embedded labels, table is Users);

Section Application;

ProjectManager:

LOAD distinct

     Name as [Project Manager],

     USERKEY as %PROJECT_MANAGER

FROM

[..\qvds\Processed Tables\SAUser.qvd](qvd);

ProgramManager:

LOAD distinct

  Name as [Program Manager],

  USERKEY as   %PROGRAM_MANAGER

FROM

[..\qvds\Processed Tables\SAUser.qvd](qvd);

Now everything is working fine except one scenario: when I have a project and any of the Project manager or the Program Manager is not listed on the security excel file then this project doesn't show up on the qvw.. even I am logged in as Admin.

Anyway I can fix this.

Thxs,

Alec

[alec1982]

Yes they are and the section access is working for the users ..

[#3]

I'm sorry but then I don't understand what's the problem if as you say this is working for users.

When you say that "The names of the users from the security excel file appear on the Program manager and Project manager list boxes on the application.." you mean that you're showing the fields [Project Manager] and [Program Manager], as Listbox objects and inside of them you get the NTNAME values from the section access table?  or what am I getting wrong?

[#4]

Try not using % and similar chars. It might solve the issue.

Plus can you attach the application.

KR,

Milan

[#5]

Alec,

I double checked it, sadly that is the way it works - asteriks (*) provides you with data values only listed in Section Access. So if some data field value exists but is not listed in section access, you won't be able to see it.

(QlikView 11 for Developers - Chapter 14: Security / Reduction fields)

Hope it helps.

KR,

Milan