section access problem

[#1]

Dear all,

I'm trying to use Section Access without success. I've this scenario:

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, Group

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, 07

USER, USER2, U2, 08

USER, USER3, U3, 06

USER, USER4, U4, 20

USER, USER4, U4, 21

USER, USER5, U5, *

];

User1 can see the group 07 only, ... user4 can see information about  20 and 21 groups...

The problem is that the data filtering  doesn't work and I don't know why. When I open the document, user and password are required, but all the users

see all the information

Some questions:

"Group" is a field name: is it important if I write it in capitals or small ?

If I logged as user1, what happens if I press the loading botton ?

Thanks in advance for your help

[cesaraccardi]

Hi,

Have you checked one of the options "Initial Data Reduction based on Section Access" or "Initial Selection based on Section Access" at the Document Properties / Opening tab?

Regards,

Cesar

[#3]

Please do what has been suggested by Cesar!

It's been very long since I worked on Section Access. But I guess you need to have Group in capitals.

To avoid the user to reload, please do the following:

Settings-->Document Properties-->Security(tab)-->uncheck: Allow User Reload

Hope it helps!

[IAMDV]

Hi,

I agree with Cesar. Please check the "Initial Data Reduction based on Section Access" and save the file. Also, I'm assuming that you are using SECTION APPLICATION statement after the INLINE table. Also, remove Section Access and directly link the Section Access table with the "Group" field and check if it behaves the way it should be...

Please read the documentation before you proceed further.

Cheers,

DV

www.QlikShare.com

[#5]

Hi,

I checked it, but data filtering doesn't work.

[hopkinsc]

Hi,

Is your 'Group' field lower or upper case in the other tables?

Make both UPPER case and see if it makes a difference.

Section access automatically converts to UPPER case but i can't remember if its just the VALUES or the fields also.

[hopkinsc]

Oh and after you have done that, reloaded and saved, you then need to exit and reopen the QVW

[IAMDV · Accepted solution]

Field name don't have to be in UPPER case. Please make sure that all the values in Group field (Not Section Access) are in UPPER case. Because whenever you use INLINE table QlikView implicitly converts the SECTION ACCESS Table in to UPPER case. If this doesn't work then please post the sample application.

Thanks,

DV

www.QlikShare.com

[#9]

Please use UPPER(Group) and check...

[#10]

Hi Deepak,

data filtering is working now.

Following your indication, I forced the upper case in my script and SA works properly.

For sure, you understood I'm a  beginner and two question jump in my mind:

- I have read that  "*" means all listed values. What does it means exactly, all the listed values into the section access ?

- If I want to have a user without any restriction, how do I have to insert it into the Section access table ?

Help again please

Thanks in advance

Stefan