Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

saumyashah90
Valued Contributor

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

Suppose i have Data's for different department for example

Header 1Header 2
DEPARTMENTDATA
ABChello
PQRHi

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.

2 Replies
sbaldwin
Contributor III

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

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

Thanks

Steve

chauhans85
Esteemed Contributor

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

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

Community Browser