Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need convert section access fiels in lower case how it is possible ( i am qlikview learner please help me)
try
lower(Fieldname) as yourfieldname
but in section access we should use uppercase right?
try this,
lower(FieldName)
eg: Lower(AbcD)
result: abcd
Hi,
Section access requires all field names and values to be uppercase.
for more details check this article,
Unfortunately you can not as Section Access rule
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