topic Section Access at Data level(for rows and columns)? in QlikView

Section Access at Data level(for rows and columns)?

saumyashah90 — Fri, 08 Feb 2013 07:57:35 GMT

Suppose i have Data's for different department for example

Now i want user1 to know data for department ABC and user2 for department PQR.

Till now what i did is

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD,DEPARTMENT
ADMIN, admin1, admin,*

USER,user1,user,'ABC'
USER,user2,user,'PQR'

];
SECTION Application;

but it is showing datas for both departments for each users.

sbaldwin — Fri, 08 Feb 2013 15:14:24 GMT

Hi, silly question but have you checked the Initial reduction based on section access checkbox?

Thanks

Steve

SunilChauhan — Fri, 08 Feb 2013 15:39:44 GMT

Use below code

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,DEPARTMENT

ADMIN, admin1, admin,*

USER,user1,user,ABC

USER,user2,user,PQR

];

SECTION Application;

Load * inline [

DEPARTMENT

ABC

PQR

];

see the attached file

hope this helps