Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.