Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ramesh1234
Contributor
Contributor

i need to convert my felids name into lower case in section access how it is possible

i need convert section access fiels in lower case how it is possible ( i am qlikview learner please help me)

5 Replies
Chanty4u
MVP
MVP

try

lower(Fieldname) as yourfieldname

but in section access we should use uppercase right?

ashwinishinde
Partner - Contributor III
Partner - Contributor III

try this,

lower(FieldName)

eg: Lower(AbcD)

result: abcd

devarasu07
Master II
Master II

Hi,

Section access requires all field names and values to be uppercase.

for more details check this article,

A Primer on Section Access

Capture.JPG

Anil_Babu_Samineni

Unfortunately you can not as Section Access rule

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Colin-Albert

The 3 golden rules of Section Access...

    Uppercase, Uppercase, Uppercase!

The field names for section access fields must be in UPPERCASE.

The data within section access fields must be UPPERCASE.

You will need to use        upper(YourFieldName) as SA_FIELDNAME


Try these links for more info.

QlikView Section Access Examples

Introduction to Section Access

Section Access