topic Re: Section access example question in QlikView

Section access example question

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

Was reviewing the examples in QlikView Section Access Examples - for some reason on example 7 only 2 users (SIMON, & ADMIN) to be able to log on. The others like PETER / PETER were getting "Access denied to this QlikView document." as if they had strict exclusion stopping them from opening the document - but that shouldn't have been the case. Any thoughts?

I'm using 11.2 SR 10.

Re: Section access example question

SreeniJD — Thu, 01 Oct 2015 04:59:43 GMT

Hi Daniel,

Please check the below comments from Colin... "remove the region field from section access part..."

Colin_Albert Mar 27, 2014 6:30 AM (in response to Wannita Veeramontri)

Hi Wannita,

Thanks for pointing out the error.

The fix is to remove the Region field from the Section Access part of the script and just use REGION_SA

The code below has commented out the Region line.

I will post an updated zip file soon.

Re: Section access example question

Daniel_Moore — Thu, 01 Oct 2015 13:33:39 GMT

Thanks Jd -

I guess he never got around to doing the load with the new code . It did work - but it shouldn't have actually created the Region field- it wouldn't have if it wasn't in the section access portion of the load script. Those who are keeping track at home the whole section access tab should look like:

section access;

trace <<< Section Access >>> ;

// This now works because the field names below are in UPPERCASE

// Users are restricted to only see the Costcentres & Region data they have access to

Access:

LOAD Access as ACCESS,

UserID as USERID,

Password as PASSWORD,

CostCentre as COSTCENTRE,

upper(Region) as REGIONSA // Region data for Section Access restrictions loaded in UPPERCASE- funny thing

// section access section Region is loaded as well - normally it wouldn't appear as a field.

FROM

[SECTION_ACCESS.xlsx]

(ooxml, embedded labels, table is Region);

trace <<< Section Application >>> ;

section Application;