Dimension is not selectable within in list

[owhittle]

Good Morning,

I am having an issue with replacing or renaming a certain field within my data set. I am also not able to select this field either within the application.

I am referring to the '-' or chr(45) in the below images.

I have tried within the app and load script to either replace the chr(45) or use a conditional statement to rename the field for it to become selectable or available however without any success. 

Has anyone seen this before?

Thank you.

Kind Regards,

Oliver

[lironbaram · Accepted solution]

hi 

this chr represent null value, you can't select null values in Qlikview 

you can replace the null value in your load script 

NullAsValue *;

Set NullValue = 'NULL';

[owhittle]

Thank you, that worked.

[lironbaram]

great , 

always happy to land a helping hand