Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am applying the section access to my application.
Below is the sample data
Section Access;
Access:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, Link
ADMIN, admin, admin, *
USER, user1, user1, US
USER, user2, user2, UK
USER, user3, user3, Fr
];
Section Application;
Sales:
Load * Inline [
Link, Country, Sales
US, USA, 1000
UK, United Kingdom, 800
Fr, France, 750
De, Germany, 940
];
Question:
1. Do we need to use the column name "Link" always in Upper case in Section access table as well as in "Sales" table.
2. is the data also needs to be in upper case under the Link column from both the tables (Access, Sales)?
Rega
yes , it has to be in the upper case ![]()
check this document
this is from QlikView help
Note!
All field names used in the transfer described above and all field values in these fields must be upper case, since all field names and field values are by default converted to upper case in section access.
this works
Section Access;
Access:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, Link
ADMIN, admin, admin, *
USER, user1, user1, US
USER, user2, user2, UK
USER, user3, user3, FR
];
Section Application;
Sales:
Load * Inline [
LINK, Country, Sales
US, USA, 1000
UK, United Kingdom, 800
FR, France, 750
DE, Germany, 940
];
LINK in Section Access and LINK in Section Application works
LINK in Section Access and Link in Section Application doesn't
The simple way is always use upper for field names and field values for section access fields