Hi Alex,
Your script has some syntax errors. Since you are using Personal Edition I cannot attach any applications for you, but use this script instead. Notes to bear in mind:
- In section access, "*" does not mean "all" but "listed values". That means that you need at least one user with all possible values, one per line, as the ADMIN user below.
- QlikView is case sensitive, fields in section access must have the same exact spelling in the data model than in the section access table
- It's not mandatory but highly recommended to add an ACCESS field so you can later on set additional security settings and make sure you don't lock yourself outof the document when testing
- Fields in section access have fixed names, ACCESS, USERID (USER is not valid)
Data:
LOAD * INLINE [
BRAND, SEGMENT, Sales
A, 1, 2000
A, 2, 100
A, 3, 12000
B, 1, 3155
B, 1, 4654
B, 2, 321321
C, 2, 544
C, 3, 4897
C, 4, 21321
C, 1, 513463
];
SECTION ACCESS;
Security:
LOAD * INLINE [
ACCESS, USERID, BRAND, SEGMENT
ADMIN, ADMIN, A, *
ADMIN, ADMIN, B, *
ADMIN, ADMIN, C, *
ADMIN, ADMIN, *, 1
ADMIN, ADMIN, *, 2
ADMIN, ADMIN, *, 3
ADMIN, ADMIN, *, 4
USER, U1, A, *
USER, U2, B, *
USER, U3, C, *
USER, U4, *, 1
USER, U5, *, 2
USER, U6, *, 3
USER, U7, *, 4
];
SECTION APPLICATION;
Hope that helps.
Miguel
.png "Luminary Alumni"){kind=icon}
. Please could you paste the script code here?.png "Miguel_Angel_Baeyens"){kind=avatar}
