topic Re: Section Access problem with linked table in QlikView

Section Access problem with linked table

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

My section access setup has always been that I assign "roles" in the user table (that is entered in the Section Access). After that I have other excel sheets that are read in the Section Application section. This has been working well, when everything was on one server.

Now I have moved to a different setup - with separate servers for QV Server and QV Publisher - and it is no longer working. The linked tables in Section Applications are not being properly applied when the user opens the applications from the access point. One of two errors occur:

1. The document opens, but with NO RESTRICTIONS

2. The document does not open, Error message saying the user does not have access to the document.

Below is an example of the script: Please help, this is a mystery to me...

Magnus

----------------------------------------

Section Access;

Load [ACCESS],

[NTNAME],

[LOCATION_ROLE],

...

FROM [QlikView_Users.xls] (biff, embedded labels, table is [Sheet1$])

;

Section Application;

Star is #;

LOAD LOCATION_ROLE,

LOCATION

FROM [Access.xls] (biff, embedded labels, table is [LOCATION$]);

Re: Section Access problem with linked table

jagan — Mon, 21 Oct 2013 09:57:59 GMT

Hi,

Did you done this

Document Properties -> Opening tab -> Select Initial Data reduction based on Section Access option

and try.

Hope this helps you.

Regards,

Jagan.

Re: Section Access problem with linked table

Mon, 21 Oct 2013 09:59:13 GMT

I might add that the document opens properly for users that don't have any restrictions in the "Section Application". And the document reloads without problems, both in the desktop and using publisher.

Re: Section Access problem with linked table

Mon, 21 Oct 2013 10:00:28 GMT

It already is like that...unfortunately not helping.

Thanks anyway!

Re: Section Access problem with linked table

amars — Mon, 21 Oct 2013 10:12:18 GMT

Can't say what could be the issue but you can debug by using the property "Initial Selection based on Section Access".

This will select the fields on which reduction is happening.

Re: Section Access problem with linked table

Mon, 21 Oct 2013 11:13:49 GMT

Sorry, but I am not sure how to do that. I know where to uncheck the box, but not how that will help me?

Thanks,

Magnus

Re: Section Access problem with linked table

Tue, 29 Oct 2013 10:51:47 GMT

I have now resolved this issue, but it wasn't very easy. It required a change to the excel table that I use (QlikView_Users.xls above).

The user that is being setup to run the distribution service on the publisher must be registered as ADMIN in the ACCESS column. This was already OK. The problem was that the LOCATION_ROLE column had the value "ALL". When I changed this to blank, it started working. Not sure why, got the instruction from QV Support and then it works.