Help with implementing "Section Access"

[#1]

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

[MayilVahanan]

Hi

PFA

Its gives idea about section access

[#3]

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

[MayilVahanan · Accepted solution]

HI

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

[#5]

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

thanks!