topic Re: Another Section Access Issue in QlikView

Another Section Access Issue

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

Hi,

I add a section access to my document and when I open it with my qlik client it works perfectly.

It seems like I don't have data when I try to open from access point portal, in fact it returns me to userid/password screen...

Is there maybe some switch to set on management console?

(I set "Initial data reduction" and "Strict exclusion" to ON, if I set "Strict Exclusion" to OFF I enter...)

Some help?!

Re: Another Section Access Issue

prieper — Fri, 12 May 2017 13:42:32 GMT

USERID or NTNAME?

Re: Another Section Access Issue

Marcoimp — Fri, 12 May 2017 14:10:55 GMT

NTNAME

Re: Another Section Access Issue

Marcoimp — Fri, 12 May 2017 14:25:53 GMT

Here my SA.

MyAdmin enter correctly using Qlikview Client, not in the web Portal (even if I add the DOMAIN name....):

LOAD * INLINE [

ACCESS, NTNAME, CODAGENTEPORT, DOCAGENTE

ADMIN, MYADMIN,*,*

USER, AAA,*,*

USER, BBB,*,*

USER, CCC,*,*

USER, DDD,*,*

USER, EEE,*,*

USER, FFF,*,*

USER, GGG,*,*

USER, HHH,*,*

USER, III,*,*

USER, JJJ,*,*

USER, KKK,*,*

USER, LLL,*,*

USER, MMM,*, C

USER, NNN,*, C

];

CONCATENATE

//============================================================================= AGENZIE

LOAD

'USER' AS ACCESS, UPPER(LOGIN) AS NTNAME, UPPER(CODAGENTE) AS CODAGENTEPORT, 'A' AS DOCAGENTE

FROM

[..\QVD\DOCAGE_A.qvd](qvd);

CONCATENATE

LOAD

'USER' AS ACCESS, UPPER(LOGIN_L2) AS NTNAME, UPPER(CODAGENTE) AS CODAGENTEPORT, 'C' AS DOCAGENTE

FROM

[..\QVD\DOCAGE_C.qvd](qvd);

];

Re: Another Section Access Issue

prieper — Fri, 12 May 2017 14:28:39 GMT

Strange ....

Have you checked, what OSNAME() returns when opened locally and when opened from server?

Spelling is ok, in Capitals?

You are included as ADMIN?

Re: Another Section Access Issue

Marcoimp — Fri, 12 May 2017 15:13:48 GMT

The OSName() is exactly the same locally and on the portal (I uncheck the strict exclusion to see it)...

All is in Capitals, and yes I have the admin (or I can't open it in the client....)

Re: Another Section Access Issue

Peter_Cammaert — Fri, 12 May 2017 15:58:28 GMT

Note that an asterisk in a Section Access link field will only expand to all values in that field in that Section Access table, not to all the field values in your entire data model.

For example I don't see any valid values for field CODAGENTEPORT, only stars...

Re: Another Section Access Issue

Marcoimp — Fri, 12 May 2017 17:01:40 GMT

All values are loaded in user concatenated after the first inline section

So I think it's like:

ACCESS, NTNAME, CODAGENTEPORT, DOCAGENTE

ADMIN, MYADMIN, *,*

USER,AAA,*,*

...

USER,NNN,*,*

USER,NAME1,A001,A

USER,NAME2,A002,C

USER,NAME3,A003,A

USER,NAME4,A004,C

...

So the ADMIN should take all CODAGENTEPORT listed in section access table and all DOCAGENTE (A and B) loaded after that

Isn't so?

Re: Another Section Access Issue

maxgro — Fri, 12 May 2017 18:04:44 GMT

I tried this script

SECTION Access;

LOAD * INLINE [

ACCESS, NTNAME, CODAGENTEPORT

ADMIN, domain\user, 1

ADMIN, domain\user, *

];

SECTION Application;

Y: LOAD rowno() as CODAGENTEPORT, 'num ' & rowno() as FIELD1 AutoGenerate 10;

SECTION Access;

LOAD * INLINE [

ACCESS, NTNAME, CODAGENTEPORT

USER, DUMMY, 3

USER, DUMMY, 4

USER, DUMMY, 5

ADMIN, domain\user, 6

];

I can see the CODAGENTPORT 1 3 4 5 6

Concatenate seems to work in section access

Re: Another Section Access Issue

prieper — Mon, 15 May 2017 07:19:34 GMT

Concatenation works also in my scripts.

Think that the major problem is the "*", which considers only the values, which are loaded in the accesstable. If you only have "*" or the underlying data contain more entries, that in the Access-Table, users will not be able to see it.

Am therefore using a script like:

SECTION ACCESS;

STAR IS *;

AccessTable: LOAD DISTINCT 'DUMMY' AS ACCESS, MYFIELD RESIDENT .....;

CONCATENATE (AccessTable) LOAD ACCESS, NTNAME, MYFIELD FROM ....;

SECTION APPLICATION;

'DUMMY' or any other string than USER or ADMIN is ignored by QV.

The first part may also be replaced with a more performant script like

LOAD 'DUMMY' AS ACCESS, FIELDVALUE('MYFIELD', RECNO()) AS MYFIELD AUTOGENERATE FIELDVALUECOUNT('MYFIELD');

Peter

Re: Another Section Access Issue

Marcoimp — Mon, 15 May 2017 07:57:20 GMT

Where are concatenations in your examples?

It's true, the first agents are with "*" because are particular agents and they have to see everything.

All other agents are concatenated by some Loads from external qvds:

LOAD INLINE ......

CONCATENATE

LOAD ..... FROM QVD

CONCATENATE

LOAD .... FROM QVD

I know "*" match only those values listed in section access. It's ok. Special agents (in the INLINE section) have to see only those listed in concatenated qvd tables, don't need to load DUMMIES values.