topic Re: section access - data reduction - captial letter required? in QlikView

section access - data reduction - captial letter required?

laujerry — Mon, 26 Jan 2026 18:19:17 GMT

if i want to use section access to reduce data for a field

that field name must be in upper case (and not even a space between?)

so how about if the field in my data model does not fulfill the condition (e.g. CompanyCode)?

is there no way to perform section access but only changing the field name to capital letters (COMPANYCODE)?

Thanks

==================================================

e.g. (from this community)

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, AFRICA

USER, USER2, U2, AMERICA

USER, USER3, U3, ASIA

USER, USER4, U4, EUROPE

USER, USER5, U4, AMERICA

USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [

REGION, PROFIT

AFRICA, 1000

AMERICA, 2000

ASIA, 3000

EUROPE, 4000

OCEANIA, 5000

];

Re: section access - data reduction - captial letter required?

fkeuroglian — Sat, 24 May 2014 17:51:32 GMT

Hi, you dont have to change your dimension name, you can use UPPER() functions to do this

see this example

SECTION ACCESS;

Directory;

LOAD ACCESS,

NTNAME,

GROUP,

UPPER([DIVISION Id]) as [DIVISION ID]

FROM

USER.xlsx

(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

Directory;

LOAD

GROUP,

SHEET1,

SHEET2

FROM

SHEET.xlsx

(ooxml, embedded labels, table is Sheet1);

[Division Table]:

LOAD * INLINE [

DIVISION ID, description, Employee

01, bird, fernandoperez

01, bird2, fernandoperez

02, food, marcosaguirre

];

hope this helps

Fernando

Re: section access - data reduction - captial letter required?

laujerry — Sun, 25 May 2014 05:44:24 GMT

hi Fernando

sorry i get confused now, for the capital letter issue

are we going to change the column header or column cell values as capital letters?

i think the upper function in bold letters is only converting column cell values as capital letters

so in your example, the [Division Table] will be the fact table right?

can you explain briefly the fields in section application? thanks