topic Help with implementing "Section Access" in QlikView

Help with implementing "Section Access"

Mon, 03 Dec 2012 20:34:07 GMT

Hi! I'm new to QlikView and am trying to restrict access to certain data based on the user's credentials. I have section access and section application defined inline. The script seems to be working fine because i am prompted for a user name and password everytime I try to open the QV document. However, the problem seems to be that the reduction isn't really happening as expected.

For example, my script is as follows:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, admin, <password>

ADMIN, user1, <password>

USER, user2, <password>

USER, user3, <password>

USER, user4, <password>

];

Section Application;

LOAD * Inline [

USERID, p_num

admin, 0

admin, 10

admin, 20

admin, 80

user1, 0

user1, 10

user1, 20

user2, 10

user3, 20

user4, 30

];

What I expect is that when I login as user1, I should only be able to see data for p_num values 0, 10, and 20. But I also see data for p_num = 30.

More importantly and much more baffling is the fact that I am only able to login as admin and user1, who are both defined as "ADMIN". I am not able to login using any of the other logins for users 2, 3 and 4 (who are coincidentally defined to have "USER" access only!).

Can somebody please help me out? Any information you can provide is greatly appreciated.

thanks,

Haritha

Re: Help with implementing "Section Access"

MayilVahanan — Mon, 03 Dec 2012 20:41:30 GMT

PFA

Its gives idea about section access

Re: Help with implementing "Section Access"

Mon, 03 Dec 2012 20:45:18 GMT

Hi! thanks for your response, but I have a personal edition of QV so I cannot open documents created by other users. Can you please post the script here?

thanks,

Haritha

Re: Help with implementing "Section Access"

MayilVahanan — Mon, 03 Dec 2012 20:51:45 GMT

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

In this example, admin can see both dept.. UserID sales can able to see only sales dept.

Hope it helps

Re: Help with implementing "Section Access"

Mon, 03 Dec 2012 21:00:50 GMT

Thanks so very much! I thought I was doing the same thing, but your script format worked.

thanks!