Section Access field names: Upper case or not

paolo_cordini — Thu, 06 Feb 2025 10:27:49 GMT

since ever, it is well known that field names in Section Access must be written in Upper Case.
This is well documented for all Qlik Sense editions (and Qlikview too)

Nevertheless, sometimes Section Access is working even with Lowercase field names.

This simple script is working in a test app. Field1 is limited to 'A' value.

Section Access;

LOAD

'USER' AS ACCESS,

'username@domain.com' as USER.EMAIL,

'A' as Field1

AUTOGENERATE 1;

Section Application;

Table:

LOAD * INLINE [

Field1

];

So why bother with translating to upper case if it working anyway? Is there any deterministic rule to this behaviour?

By the way, the same table with an INLINE instead of AUTOGENERATE will result in an upper case field name (FIELD1), therefore in the above situation, the field won't be filtered.

Regards

Paolo

Re: Section Access field names: Upper case or not

henrikalmen — Thu, 06 Feb 2025 14:41:54 GMT

I haven't tested if it works as you say, but I'll assume you're correct. "So why bother with translating to upper case if it working anyway?" Well, I'd say you should bother because the section access syntax defines it. If it works now, it doesn't necessarily mean that it will still work in the next version.

topic Section Access field names: Upper case or not in App Development

Section Access field names: Upper case or not

Re: Section Access field names: Upper case or not