Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';
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';
Thank you, that worked.
great ,
always happy to land a helping hand