Discussion Board for collaboration related to QlikView App Development.
I have two fields that I want to restrict access to
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,REDUCTION2ADMIN,ADMIN1,ADMIN1,USER,'USER1','USER1',1,2USER,'USER2','USER2', ,2
];SECTION Application;OCEntity:LOAD * Inline [REDUCTION, 'OC Entity'1,MF_UK];SECTION Application;ReduceParts:LOAD * Inline [REDUCTION2, 'Product Category'2,PARTS];
Have a look at below post.
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