topic Section Access Question in QlikView

Section Access Question

hopkinsc — Wed, 17 Oct 2012 09:17:41 GMT

Hi All,

I am trying to set up section access on a qvw, i want to restrict by 2 fields though and i am just wondering the best and easiest way of doing it.

an example of what i want to do is..

i want to be able to restrict by Sales Region and SalesMan

so admin can see ALL

but USER1 can see region LG and SalesMan SP1

USER2 can see region LG and DIR and salesMan SP1

Can anyone help please?

Wed, 17 Oct 2012 10:33:50 GMT

Hi,

try this.

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, SalesRegion, SalesMan

ADMIN, ADMIN, ADMIN, ,

USER, USER1, PWD1, LG, SP1

USER, USER2, PWD2, LG, SP1

USER, USER2, PWD2, DIR, SP1

];

SECTION APPLICATION;

Have fun