Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Section access with two fields

Hi All,

I have scenario for section access as below

I have user security excel where i have fields like, ACCEE USERID Channel Project

suppose,

    

ACCESSUSERID ChannelProjectCode
USERU1DC1P-12438
USERU1

DC2

P-12429
ADMINU2**

in my original data I have ProjectCode for DC1 is P-12438,P-12429,P-13421,P-13241 so, whatever codes mentioned in user access file for DC1 those should be excluded when user access application i.e. user can see only DC! data for project code P-13421,P-13241 but, admin user should see all data.

let me know your suggestions if anyone have already implemented.

Thanks!

1 Reply
enriquem
Creator
Creator

Hello,

I'm using this code to let permission to the user:

SECTION Access;

LOAD * INLINE [

    USERID, PASSWORD, ACCESS

    Admin, Admin, ADMIN

    User1, User1, USER

    User2, User2, USER

    User3, User3, USER

];

Section Application;

PemissionTable:

LOAD * INLINE [

USERID, CanSee

Admin,1

User1,0

User2,0

User3,1

];

With this code my user can see or not something from my project. Remember put the conditional to the object like this:

CanSee=1

Regards.

Kind Regards,
Enrique Mora.