Section access with two fields

vijetas42 — Thu, 12 Jan 2017 10:04:45 GMT

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,

ACCESS	USERID	Channel	ProjectCode
USER	U1	DC1	P-12438
USER	U1	DC2	P-12429
ADMIN	U2	*	*

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!

Re: Section access with two fields

enriquem — Thu, 12 Jan 2017 10:40:43 GMT

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.

topic Section access with two fields in QlikView

Section access with two fields

Re: Section access with two fields