Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Section Access Issue

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Could you post a sample of your section access security table?

If you put a star * in the columns %PROJECT_MANAGER and %PROGRAM_MANAGER for user ADMIN, try with just a blank field value.

View solution in original post

13 Replies
Highlighted
MVP
MVP

Could you post a sample of your section access security table?

If you put a star * in the columns %PROJECT_MANAGER and %PROGRAM_MANAGER for user ADMIN, try with just a blank field value.

View solution in original post

Highlighted
Specialist II
Specialist II

Hi Swuehl,

Here is a sample of the security file:

ADMINNA\ATLHARFB***

1



USERSERVER99\MDAVIMDAVIMDAVI*1
ADMINSERVER99\NEXCNBHATNBHAT*27

I didn't get what you mean by blanck field value.

Thxs so much for all your help.

Alec

Highlighted
MVP
MVP

I would try removing the star symbol '*' from columns %PROJECT_MANAGER and %PROGRAM_MANAGER, just leaving the field empty for the ADMIN line.

Highlighted
Specialist II
Specialist II

Thxs for all your help!

Highlighted
Specialist II
Specialist II

Hi Swuehl,

I noticed an issue happening when i do the space instead of the *

The names of the users from the security excel file appear on the Program manager and Project manager list boxes on the application..

for example, the the QV administrator User name which is used to reload the qvws appears on the list boxes while it is not part of any of the projects..

Any idea on what could be done wrong?

Thxs again for all your help!

Alec

Highlighted
Specialist II
Specialist II

Hey guys,

Anybody has a solution for my issue 🙂

Thxs for all your help..

Alec

Highlighted
Not applicable

Instead of using space, leave the filed empty for the ADMIN. An space is a value after all.

Highlighted
Specialist II
Specialist II

Hi,

The fields are empty.

and assuming if they are taking a vlue of space then i should not see any of the data..

Thxs for all your help!

Alec

Highlighted
Not applicable

Mmmm it will be hard to tell, but are ProjectManager and ProgramManager tables linked in the Data Model?