Control of sheet access

helen_pip — Fri, 01 Feb 2013 11:46:37 GMT

Hello

I have written some section access in my script which will allow users to see certain sheets depending on whether the sheet has a 0 or a 1 in my excel spreadsheet. However I need some help amending this script, as every time the document is opened, I get prompted for my User ID

The first part of the script shows whether a user can see patient level or not

The second part of the script shows what sheets a user can see

Can anyone help me with the script so I do not get prompted for my UserID every time

I have attached a copy of the spreadsheet also

Many Thanks

Helen

Section Access;

LOAD

'S-1-5-21-133631074-2907035605-456469473' as NTDOMAINSID,

USER as NTNAME,

ACCESS as ACCESS,

PATIENT_LEVEL,

SHEET_ACCESS

FROM

C:\QLIKVIEW\DEVELOPMENT\ACCESS\Dashboard_Access.xlsx

(ooxml, embedded labels, table is ACCESS);

Section Application;

ACCESS_CONTROL:

load * inline [

PATIENT_LEVEL,access_type

1,Y

0,N

];

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, LEVEL

ADMIN, pip, NO_DETAIL

];

Section Application;

LOAD * INLINE [

LEVEL,VALID

DETAIL, 1

NO_DETAIL,0

];

topic Control of sheet access in QlikView

Control of sheet access