Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with reduction in section access

binary load blah blah blah;

section access;

LOAD

* INLINE [

    ACCESS, NTNAME, "Sale Year"
    ADMIN, domain1\user1, 2008
    USER, domain1\user2, 2009
    USER, domain2\user1, 2010
    USER, domain2\user2,
]
;

Section Application;
LOAD * INLINE [
"Sale Year"
2009
2010
2011
2012
2013
]
;

I want to reduced based on a Sale Year which is the column in the data model. This doesn't work at all... Either from the desktop or from the access point. Can you kindly help? domain2\user2 should have access to all years, but the other users need to be set up as seen here.

14 Replies
tresesco
MVP
MVP

all the year values have to be there in the section access. try like this:

Section Access;

LOAD

* INLINE [

    ACCESS, NTNAME, "Sale Year"
    ADMIN, domain1\user1, 2008
    USER, domain1\user2, 2009
    USER, domain2\user1, 2010
    USER, domain2\user2, 2008

    USER, domain2\user2, 2009

    USER, domain2\user2, 2010

    USER, domain2\user2, 2011

    USER, domain2\user2, 2012

    USER, domain2\user2, 2013


]
;

Section Application;
LOAD * INLINE [
"Sale Year"
2009
2010
2011
2012
2013
]
;

Not applicable
Author

Hi,

Make sure, the field "Sales Year" is exists in your data model ( which is in your binary load). Also, Put the check mark for the option Document Properties -> Opening -> "Initial Data Reduciton Based on Section Access".

Not applicable
Author

Yes, it exists and i have done the set up in the Opening tab as well. Still no luck.

Not applicable
Author

Hi,

I have a small doubt from your Section Access: How come user1 have both ADMIN and USER as ACCESS types?

Ok, when you have logged in to your application by USER1 then how the applicaiton can treat you, whether you are ADMIN or USER?

tresesco
MVP
MVP

we are missing one basic:

Everything under section access has to be in CAPITAL letters.

Not applicable
Author

actually it is a typo, different users in different domains. apologies.

Not applicable
Author

why? my osuser() returns domain name in caps and user name in lowercase.

Not applicable
Author

Hi,

Is it possible to attach your application?

tresesco
MVP
MVP

Though, this does not apply to INLINE data, but if you are loading via an external data source, must be loaded in upper case.