How to use a state field that contains both state code and a state name?

[Anonymous]

Hi All,

I am trying to insert a field to the drilldown dimension with a full state name, for example: "NY - New York" and I am getting an error.

Only when I am using a state code or a state name fields it works properly.

Is there any way to use a full state name?

Thanks for the help

[jaumecf23]

Hi,

You need to create a new field like this in the script for example:

[state code] & ' - ' & [state name] as [full state name]

[sunny_talwar]

Is this for QlikView or Qlik Sense? Do you get an error message?