Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

section access problem

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

1 Solution

Accepted Solutions
Luminary
Luminary

Re: section access problem

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

14 Replies
cesaraccardi
Valued Contributor

Re: section access problem

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

Not applicable

Re: section access problem

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!

Luminary
Luminary

Re: section access problem

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

Not applicable

Re: section access problem

Hi,

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

hopkinsc
Valued Contributor II

Re: section access problem

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
Valued Contributor II

Re: section access problem

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

Luminary
Luminary

Re: section access problem

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

Not applicable

Re: section access problem

Please use UPPER(Group) and check...

Not applicable

Re: section access problem

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

Community Browser