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 |
| |
| ]; |
