topic Re: Reduction Fields in QlikView

Reduction Fields

robert99 — Thu, 17 Jul 2014 12:04:46 GMT

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
];

Re: Reduction Fields

ashfaq_haseeb — Thu, 17 Jul 2014 12:08:02 GMT

Hi,

Have a look at below post.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields

Regards

ASHFAQ

Re: Reduction Fields

robert99 — Thu, 17 Jul 2014 12:26:29 GMT

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