Qlik Community

Ask a Question

QlikView Management

Discussion Board for collaboration on QlikView Management.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

section access - data reduction - captial letter required?

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

];

2 Replies
Partner
Partner

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

Creator
Creator

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