Section access Admin * is not working

[mahitham]

Hi Experts,

Can any one please help me on below issue.

I am working on Section access for data level security.

I have created section access Excel file like below

Excel Source:

USERID,ACCESS,ID

SF/ERG,ADMIN,*

SF/UKJ,USER,4856A

Script:

Section Access;

Load

Upper(USERID)       as      USERID,

Upper(ACCESS)     as      ACCESS,

Upper(ID)                as      ID

From ….

Section Application;

Employee:

Load

Upper(ID)                as      ID,

Name,

Department,

Branch

From.....

But when I login with the SF/ERG ADMIN account I am able to see only 4856A ID in ID Field which is assigned to the user.

But as an  admin I need to see all the ids in ID Field.

Please let me know am I missed any thing

Thanks in advance.

[prathipsrinivas]

The Star (*)in the Section Access means not all the data but the values mentioned in the Section Access only.

May be this will help:-

Section Access. All users with exception of some

[agigliotti]

i suggest you to take a look at working with SA in Qliksense qmc

there you'll find the script needed to achieve it.

I hope it can help.

[mahitham]

Hi agigliotti,

Thanks for your reply.

I have gone through the thread. Could you please check the below code once for my scenario.

Please let me know am I need to make any changes in this script and please let me know do we need to make any changes in QMC to implement the below script.

I am looking for the script which is directly working in the app without making any changes in QMC.

SECTION ACCESS;

TEST:

LOAD *

INLINE [

ACCESS, USERID,  ID

ADMIN,  SF/ERG,    ALLVALUES

USER,  SF/UKJ,      4856A

];

SECTION APPLICATION;

STAR IS '*';

tab1:

load

    ID,

    ID      as  SEC_ID

resident TEST where ID<> 'ALLVALUES';

concatenate

load

    ID,

    '*'      as    SEC_ID

resident TEST where ID = 'ALLVALUES';

Excelsource:

Load

ID,

Name,

Department,

Branch

From lib://Excel.qvd..

Thanks in advance

[agigliotti]

I can't see the field SEC_ID in your Excelsource table.

Thus it can't works.

[JordyWegman]

Hi Mahitha,

You should not fill anything in for the Admin.

When you use a wildcard, only the rows that are filled in will be shown to the employee!

If you add a non existing value or blank value it will show all values for an Admin.

If you do this for a user, the access is denied.

Regards,

Jordy - Climber