Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Section Access prob

Hey,

I applied the section access in my application as:

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

SASH,SASH,SASH

LORNE,LORNE,LORNE

];

Section Application;

But when i opened it again, and provide the userid and password as SASH, i am getting all data rather than SASH data only.

Where am i wrong?

Thanks

15 Replies
daniel_kusiak
Creator II
Creator II

Is it the same with LORNE?

qlikmsg4u
Specialist
Specialist

You need to specify Access type As ADMIN or USER

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

PrashantSangle

Hi,

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

Then go to Document Property->Opening->Select Initial Data Reduction Based on Section Access.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
awhitfield
Partner - Champion
Partner - Champion

Hi Nikhil,

is that your entire Section Access Script? All that's doing is making a user enter a user name and password.

Andy

nikhilgarg
Specialist II
Specialist II
Author

YES, can you suggest something?

daniel_kusiak
Creator II
Creator II

Add Section Access; before LOAD * INLINE.

It should look like this:

Section Access;

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

Then go to Settings->Document Properties->Opening and set Initial Data Reduction Based on Section Access.

After that you can omit data for user like SASH or LORNE by adding OMIT to INLINE. You can also set user privilages

Settings->Document Properties->Security. Remeber to set Admin Override Security.

nikhilgarg
Specialist II
Specialist II
Author

Ohk, so what should i do ?

My first statement is binary load then:

Section Access;

LOAD * Inline [

ACCESS , USERID , PASSWORD

ADMIN, ADMIN, ADMIN

USER,SASH,SASH

USER,LORNE,LORNE

];

Section Application;

In document setting , i have checked :

1: Initial data reduction based on section access

2: Section Exclusion

daniel_kusiak
Creator II
Creator II

Do you do INLINE by Insert->Section Acces->Inline?

awhitfield
Partner - Champion
Partner - Champion

HI Nikhil,

maybe you should check out the attached document