Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Section access on Multiple Dimensions

Hi ,

Currently i have section access on one dimension called Department but i want to put filter on another dimension called Region,how can i incorporate that into the below code.Thanks.

section access;
LOAD
     UPPER(ACCESS) as ACCESS,

     UPPER(USERID) as USERID,

     UPPER(REDUCTION) as REDUCTION

inline [

ACCESS, USERID, REDUCTION
USER,DOMAIN\SJANARDHAN,D1550
USER,DOMAIN\VKALLURI,D1500

];

2 Replies
sureshqv
Esteemed Contributor III

Re: Section access on Multiple Dimensions

chauhans85
Esteemed Contributor

Re: Section access on Multiple Dimensions

SEE THE EXAMPLE BELOW


admin have all dept and region access

user has their own dept and region link to it.

SECTION ACCESS;

Load * Inline [

ACCESS,USERID,DEPT

ADMIN,SUNIL,*

USER,AMIT,IT

USER,SMIT,APP

USER,AJIT,SUPPORT

USER,AJAY,NEW

];

SECTION Application;

lOAD * INLINE [

DEPT,REGION

IT,EAST

APP,WEST

SUPPORT,NORTH

NEW,SOUTH

];