topic Re: SECTION ACCESS in QlikView

SECTION ACCESS

Chanty4u — Mon, 26 Jan 2026 18:19:17 GMT

hi all,

i hve created section access to my document lik below..

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, %LEVEL

ADMIN, ADMIN, ADMIN, *

USER, USER, USER, Project1

USER1, USER1, USER1, Project2

];

SECTION Application;

when i opened with ADMIN it is shwng all projects THAT IS OK

but wen i open with user AND user1 ... it alsow opening all projcets.....

i want to open user only project1

user -project2

Re: SECTION ACCESS

Anonymous — Fri, 11 Dec 2015 10:12:20 GMT

Check this option...

see the attachment..

Re: SECTION ACCESS

its_anandrjs — Fri, 11 Dec 2015 10:13:24 GMT

Try with this by capital words on the field name and in the model as well as.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, %LEVEL

ADMIN, ADMIN, ADMIN, *

USER, USER, USER, PROJECT1

USER1, USER1, USER1, PROJECT2

];

SECTION Application;

Or in your model as well for the field like use of UPPER function

Load

Upper (%LEVEL) as %LEVEL

...

From Location

Regards

Anand

Re: SECTION ACCESS

Chanty4u — Fri, 11 Dec 2015 10:15:30 GMT

BALRAJ.. I HVE TRIED EVEN THOUGH IT IS SHWNG SAME...

Re: SECTION ACCESS

Anonymous — Fri, 11 Dec 2015 10:22:23 GMT

Put all the information in CAP as suggested by Anand

Re: SECTION ACCESS

Chanty4u — Fri, 11 Dec 2015 10:23:42 GMT

NICE ANAD......THNX IT WORKS EXACTLY.....BUT WEN OPENNG WITH ADMIN IT IS SHWNG prjoect1 and project2 only.

i hve prj1

prj2

prj3

prj4

prj5

Re: SECTION ACCESS

its_anandrjs — Fri, 11 Dec 2015 10:28:24 GMT

Check settings for ADMIN use * other wise keep blank there.

Regards

Anand

Re: SECTION ACCESS

its_anandrjs — Fri, 11 Dec 2015 10:45:26 GMT

Keep Blank in the field %LEVEL will solve your problem.

Re: SECTION ACCESS

Peter_Cammaert — Fri, 11 Dec 2015 10:54:11 GMT

Correct. This * will only match the values that are present in the %LEVEL field in your SectionAccess table, not those additional values in the %LEVEL field in Section Application.

Note that this behavior is ok in QV Desktop. In a published document on the server, the story is different again. In the AccessPoint, everybody is a USER. And while a blank link field will let ADMINs enter this document in QV Desktop, it will get them kicked out if you enable 'Strict Exclusion'.

Best,

Peter

Re: SECTION ACCESS

Chanty4u — Fri, 11 Dec 2015 11:04:51 GMT

IF I WANT TO GIVE PERMISSION TO user to access project1 and project2 how can i give?

Re: SECTION ACCESS

rubenmarin — Fri, 11 Dec 2015 11:32:12 GMT

Hi suresh, for Admin you'll need to load all different values for %LEVEL, so admin has access to all projects throught AP, and to give some user access to more than one project you can add a line for the same user:

Section Access;

Values:

Load Distinct Upper (%LEVEL) as %LEVEL //This way %LEVEL has all the values when you use *.

From Location;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, %LEVEL

ADMIN, ADMIN, ADMIN, *

USER, USER, USER, PROJECT1

USER, USER, USER, PROJECT2

USER, USER1, USER1, PROJECT2

];

SECTION Application;

....

Re: SECTION ACCESS

ahmar811 — Fri, 11 Dec 2015 11:42:44 GMT

try this link

Sheet level access

hope this help you

Regards

Ahmar

Re: SECTION ACCESS

Chanty4u — Fri, 11 Dec 2015 12:07:09 GMT

WHEN I WAS APPLYING SHEE LEVEL SECURITY IT IS NT WRKNG...

Re: SECTION ACCESS

Chanty4u — Fri, 11 Dec 2015 12:08:42 GMT

user1 only see the sheet1 and sheet3

user2 want to c sheet2 and sheet3

my tabs names like introduction and defects test lik dat

how can i achieve?