topic Section Access in QlikView

Section Access

Thu, 04 Nov 2010 11:34:00 GMT

Currently I'm trying to implement section access for 2 seperate users on a QlikView document. I wondering if someone might be able to help me with this piece of code.

section

access;

Load

[ACCESS], [USERID], [PASSWORD]

admin

, pei, 6412,

user

, ortho, 9523,

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

section

application;

This is the error I'm receiving. Hopefully someone might be able to offer some advice.

Syntax error, missing/misplaced FROM:
Load [ACCESS], [USERID], [PASSWORD]
admin, pei, 6412,
user, or, 9523,

FROM [\\\QlikViewReports\SecurityDemo1.xls] (biff, embedded labels, table is Access$)
Load [ACCESS], [USERID], [PASSWORD]
admin, pei, 6412,
user, or, 9523,

FROM [\\\QlikViewReports\SecurityDemo1.xls] (biff, embedded labels, table is Access$)

Section Access

Thu, 04 Nov 2010 12:02:57 GMT

may be the last comma indicates it's waiting for another field

christian

Section Access

kji — Thu, 04 Nov 2010 12:15:07 GMT

What you got is a mix of an inline load and a load from file.

Use either:

LOAD * INLINE [
[ACCESS], [USERID], [PASSWORD]
admin, pei, 6412,
user, or, 9523
];

or

Load [ACCESS], [USERID], [PASSWORD]
FROM [\\QlikViewReports\SecurityDemo1.xls] (biff, embedded labels, table is Access$);

Section Access

Thu, 04 Nov 2010 12:35:35 GMT

Thanks for the replies, much appreciated...

I put this code in but got back an error straight away. I was hoping to restrict the user "ortho" from the Sheet "graphs", but i've clearly got something wrong, any ideas?

Garbage after statement

LOAD * INLINE [
[ACCESS], [USERID], [PASSWORD], [OMIT]
ADMIN, PEI, 6412
USER, ORTHO, 9523, GRAPHS
]

Section Access

Anonymous — Thu, 04 Nov 2010 17:32:12 GMT

Brian,
Load inline is using square brackets, and you have the fields names in brackets too - it may cause a problem. Remove them
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, PEI, 6412
USER, ORTHO, 9523, GRAPHS
];

And make sure you have semicoloms (";") in right places.