Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
robert99
Specialist III
Specialist III

Reduction Fields

I have two fields that I want to restrict access to

Product Category

Parts

Equipment

and

OC Entity

MF_UK

MF_US

MF_SPAIN

What Im trying to do is

Restrict user2 just to Product Category = Parts

Restrict user1 to OC Entity = MF_UK

Admin1 can access everything

I have tried the following (noted below) but it does not work

If I just use one reduction field everything works as it should

But can QlikView handle two reduction fields.

And if so how should this be done

Thanks for any help

Access;

LOAD * Inline [

ACCESS,USERID,PASSWORD,REDUCTION,REDUCTION2
ADMIN,ADMIN1,ADMIN1,
USER,'USER1','USER1',1,2
USER,'USER2','USER2', ,2

];
SECTION Application;
OCEntity:
LOAD * Inline [
REDUCTION, 'OC Entity'
1,MF_UK]
;

SECTION Application;
ReduceParts:
LOAD * Inline [
REDUCTION2, 'Product Category'
2,PARTS
]
;

2 Replies
ashfaq_haseeb

robert99
Specialist III
Specialist III
Author

OK thanks

All fields in Section Access must be upper case. Hence, the reducing field must be in upper case also in the data. Use the Upper() function and name the fields in upper case.

I will try this when back at work on monday