Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
konidena
Creator
Creator

Section Access

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

2 Replies
avinashelite

yes , it has to be in the upper case

check this document

maxgro
MVP
MVP

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