topic Re: Section Access in QlikView

Section Access

konidena — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Section Access

avinashelite — Wed, 09 Mar 2016 17:55:35 GMT

yes , it has to be in the upper case

check this document

Re: Section Access

maxgro — Thu, 10 Mar 2016 00:17:32 GMT

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