Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
neerajthakur
Creator III
Creator III

Section Access on two different fields

Hi All 

I have 3 users

Admin,Region_1,CFS_1

and two fields as REGION_NAME and SA_STATE

for admin there is no restriction on both the fields

for Region_1 user Region_NAME='REGION_1' NO RESTRICTION ON SA_STATE

FOR SA_STATE USER REGION_NAME CAN BE ANYTHING BUT SA_STATE should be STATE1

I have attempted following but not getting correct results

Section Access;

ACCESSTABLE:
Load * Inline [
ACCESS,USERID
ADMIN,EAGLE
USER,REGION_1
];

Section Application;
Star is '*';

ReductionTable:
Load * Inline [
USERID,REGION_NAME
EAGLE,*
REGION_1,REGION_1
];

Star is;

Section Access;

ACCESSTABLE:
Load * Inline [
ACCESS,USERID
ADMIN,EAGLE
USER,CFS_1
];

Section Application;
Star is '*';

ReductionTable:
Load * Inline [
USERID,SA_STATE
EAGLE,*

CFS_1,STATE_1
];

Star is;

NOTE: BOTH THE FIELDS ARE IN SAME TABLE.

 

#URGENT #QLIKSENSE @support @PrashantSangle @marcus_sommer @swuehl @sunny_talwar @tresesco 

Thanks & Regards,
Please Accepts as Solution if it solves your query.
Labels (3)
1 Reply
Bill_Britt
Former Employee
Former Employee

HI,

Take a look at section 6 in the attached.

 

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.