Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
commonqlik
Contributor II

Re: Error message assistance request

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

flipside
Valued Contributor II

Re: Error message assistance request

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.

Employee
Employee

Re: Error message assistance request

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.

commonqlik
Contributor II

Re: Error message assistance request

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