Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access / Section Application Issue

I'm trying to apply a filter on load of a document, based on the user specified. I've looked at examples, and have some that work. Yet, for some reason, when I create one, mine don't work. I know I'm missing something, likely simple, but haven't had any luck figuring it out.

A very simple example of what I'm running into problems with is at http://www.insaneprojects.com/SecuritySample.qvw

If someone can take a look and tell me what obvious thing I'm missing, I'd appreciate it.

Thanks!

-Kevin

1 Solution

Accepted Solutions
disqr_rm
Partner - Specialist III
Partner - Specialist III

oops!!! my bad. I had typo,... sorry.

Try this code. Only chaged the case of SP. It's very picky in the section access. You could also do upper() function as preload.


Section Access;
Access01:
LOAD * INLINE [
ACCESS, USERID, SP
ADMIN, admin, *
USER, user, *
USER, kevin, CENTRAL
USER, ricardo, EASTERN
];
Section Application;
Access_Application:
Load * INLINE [
SP, Region
CENTRAL, C
EASTERN, E
NORTHERN, N
SOUTHERN, S
];


View solution in original post

11 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

What is the user/password of your document?

Make sure that you have the "Initial Data Reduction...." checkbox "on" under document properties and "Opening" tab.

Not applicable
Author

Hello Rakesh!

I am also struggling with something same like this. I wish you could see the below post can help me out. It is so bad that i don't know how to define the admin due to some reason in the data structure and also not proper understanding of Section access in qlikview. In my document admin is not able to see the over all data so it is so bad. User and the USER level are only able see the data. I want the admin login to see all the USER' s data.

Please look into the below post and help me out. If anything is not understandable please let me know because so many times posted the same problem in the forum but no helped me out it the last. So not sure whether they are not able to understand anything in my or what.

Hope you to receive reply from you atleast.

http://community.qlik.com/forums/t/25669.aspx

http://community.qlik.com/forums/t/25323.aspx

To open the attachment application, use userid: 0010012021, password: c2info99

Thanks and Regards,

Rikab

Not applicable
Author

Hi All,

I don't know whats wrong with this post. I am not getting much reply which and all are related to this post. I don't know why! Is it not understandable or missing any information. But i seriously in need of solution for this problem. Hope members of this community will consider this seriously and provide solution for this problem at the earliest.

Thanks and Regards,

Rikab

Not applicable
Author


Rakesh wrote:
What is the user/password of your document?
Make sure that you have the "Initial Data Reduction...." checkbox "on" under document properties and "Opening" tab. <div></div>


Sorry; I forgot that rather key piece of info!

Section Access;
Access01:
LOAD * INLINE [
ACCESS, USERID, SP
ADMIN, ADMIN, *
USER, USER, *
USER, Kevin, Central
User, Ricardo, Eastern
];


Initial data reduction is checked.

-Kevin

Not applicable
Author

Is a field called SP exists in the section application of your QlikView File ?

this field [SP] must include at least 'Central' and 'Eastern' values and it should be linked to the other part of your QlikView Data Model.
If you still have difficulties, please read the QlikView reference Manual Book 1, 26.8 Dynamic Data Reduction first.There is explanations on an example

Note : Please use only USER or ADMIN value in the ACCESS field

Hopes it helps

Regards

Not applicable
Author


Bertrand wrote:Is a field called SP exists in the section application of your QlikView File ?
this field [SP] must include at least 'Central' and 'Eastern' valuesand it should be linked to the other part of your QlikView Data Model.


Yes.

If you still have difficulties, please read the QlikView reference Manual Book 1, 26.8 Dynamic Data Reduction first.There is explanations on an example


I've reviewed that, I have reviewed other examples that work, but for some reason, when I try to implement it myself, it does not work.

When I view the associated database, it also shows the proper link between the table created in Section Application and in the data itself.

-Kevin

disqr_rm
Partner - Specialist III
Partner - Specialist III

I still cannot open your sample document with the user/password information you have provide. Please double check and let us know.

Not applicable
Author


Rakesh wrote:
I still cannot open your sample document with the user/password information you have provide. Please double check and let us know. <div></div>


I just downloaded a copy and was able to access via a username of admin and a password of admin.

-Kevin

disqr_rm
Partner - Specialist III
Partner - Specialist III

oops!!! my bad. I had typo,... sorry.

Try this code. Only chaged the case of SP. It's very picky in the section access. You could also do upper() function as preload.


Section Access;
Access01:
LOAD * INLINE [
ACCESS, USERID, SP
ADMIN, admin, *
USER, user, *
USER, kevin, CENTRAL
USER, ricardo, EASTERN
];
Section Application;
Access_Application:
Load * INLINE [
SP, Region
CENTRAL, C
EASTERN, E
NORTHERN, N
SOUTHERN, S
];