Error message assistance request - Qlik Community

Report Inappropriate Content · ‎2014-09-26

Hi

I'm getting an error message when trying to create an expression. The expression has been directly copied over from the input Excel file, so there are no spelling errors, additional spaces etc.

Desired expression is:

Count([GAS SERVICING ONLY Q11. If the appointment was inconvenient how satisfied were you with options to change it?])

Error message is:

Bad field name(s): [GAS SERVICING ONLY Q11. If the appointment was inconvenient how satisfied were you with options to change it?]

Any ideas on how to resolve?

Regards

Mike Hack

Anonymous · ‎2014-09-26

i think GAS SERVICING FILEDS NAME IS NO IN PROPER MANNER PLS CHECK IN DATA BASE ONCE

flipside · ‎2014-09-26

Do you mean you are building an expression in a front end object? If so, I would recommend renaming long field names to something more manageable and preferably containing no spaces. Excel column headers can have hidden characters if it comes from cells that have been merged.

ToniKautto · ‎2014-09-26

The error message indicates that you do not have a field with the name in your application's data model.

A Reason for this can be that you have loaded the Excel file without embedded labels. Please attach a copy of your load script and it will be easier to determine how you can address the issue.

Anonymous · ‎2014-09-26

when u have gap between fields u should use [ ] or '' ''