topic AW:Re: section access in QlikView

section access

Mon, 05 Jul 2010 13:02:16 GMT

I'm trying to build a 'section access' based on 4 columns:
ACCESS, USERID, NTNAME and REDCOL

First three are basic Qlikview columns, last one is the link to my data.

When I define two users using a 'LOAD INLINE' statement, everything works as expected and data is reduced depending on who is opening the document.

When I add the exact same two users to an Excel sheet and load the 'section access' data from there, things are not working, I can't even open my document anymore.
For test purposes I copied the 'section access' statement that loads the Excel sheet to the 'section application', and the data that is loaded from the Excel sheet looks exactly right.

I'm totally stumped, can anyone help me out?

Definition of the two users:
USER,*,MYDOMAIN\myuser,12345
ADMIN,adminuser,*

section access

Mon, 05 Jul 2010 13:43:22 GMT

I use an Excel-file in section access and it works perfect.

Here is an example.

Anders

Section

Access;

Load

NTNAME,

[ACCESS],

[PARTS] AS COMP

FROM

[\\sthnt004\Groups\Import\V1-R1-F4\QlikView\QlikView behörigheter.xls] (biff, header is 2 lines, embedded labels, table is [QlikView$]);

Section

Application;

STAR IS *;

LOAD

* INLINE [

COMP, COUNTRYNAME

ALL, *

SE, Sweden

NO, Norway

];

section access

Mon, 05 Jul 2010 13:52:26 GMT

Got it working now.

I was loading the Excel sheet through an ODBC connection. Changed it to a LOAD as in your example and now it works. Not sure why it's not working when I load the Excel file through ODBC

AW:Re: section access

brenner_martina — Mon, 05 Jul 2010 14:25:25 GMT

Hi,

all fields and entries in the section access part has to be in capital letters! Only username, ntdomain and password can be written in lower an upper cases!