Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Hi,
Have a look at below post.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields
Regards
ASHFAQ
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