Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Section access - All access

Dear all,

Some user need to be restricted acces for some branches but most can see all of them.

when I do a little test (see below) the section access definition * doesn't seem to be recognized.

How do I convince Qlikview to allow certain users access to all fields?

Code:

Star is *; // Required if wildcard characters are used in Section Application

// -------------------- Who can access this Application --------------------

Section Access;

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635, *

User, SERVER-EU\BE11635, 'S010'

];

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Section access - All access

I think you are getting wrong with section application

Section Access;

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635, *

User, SERVER-EU\BE11635, 'S010'

];

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

You shouldn't mention NTNAME.

All you need is

Section Application;

[Branch Authorisation]:

Load * inline [TCTLOW,0SALESORG

S012,S012

];

You can also get the values from 0SALESORG doing a Resident from the table

Section application is the link between users and fields in Qlikview tables.

10 Replies
Not applicable

Re: Section access - All access

To allow all fields use empty fields

* means all listed values in fields

try this :

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635,

User, SERVER-EU\BE11635, 'S010'

];

rupe
Valued Contributor

Re: Section access - All access

Hi Kevin,

when you say that the "*" is not recognised .... what happens?

Many thanks

Not applicable

Re: Section access - All access

Thank you very much for the quick response, however, now he created a blank record...SectionAccessProblem.png

Not applicable

Re: Section access - All access

Rupert,

when I open I don't see any data

But as Bertrand mentions * means all listed values in fields not all fields

Thank you in advance,

Kr,

Kevin

Not applicable

Re: Section access - All access

I think you are getting wrong with section application

Section Access;

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635, *

User, SERVER-EU\BE11635, 'S010'

];

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

You shouldn't mention NTNAME.

All you need is

Section Application;

[Branch Authorisation]:

Load * inline [TCTLOW,0SALESORG

S012,S012

];

You can also get the values from 0SALESORG doing a Resident from the table

Section application is the link between users and fields in Qlikview tables.

SunilChauhan
Esteemed Contributor

Re: Section access - All access

after section application use

star is *;

hope this helps

heimo_ernst_wei
New Contributor III

Re: Section access - All access

I think there is a flaw in your code with:

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

You shouldn't mention NTNAME.

All you need is

Section Application;

[Branch Authorisation]:

Load * inline [TCTLOW,0SALESORG

S012,S012

];

All restrictions for access have to be in "Section Access"

See a good introduction: Introduction to Section Access

SunilChauhan
Esteemed Contributor

Re: Section access - All access

Hi,

can we use two

section application;

in code . as i see there are two section application.

Sunil

Not applicable

Re: Section access - All access

Thank you all for your help in this!!

Greatest community!