Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error message assistance request

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

4 Replies
Anonymous
Not applicable
Author

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

flipside
Partner - Specialist II
Partner - Specialist II

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
Employee
Employee

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
Not applicable
Author

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