topic Re: Dimension is not selectable within in list in QlikView

Dimension is not selectable within in list

owhittle — Sat, 16 Nov 2024 19:31:07 GMT

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

Re: Dimension is not selectable within in list

lironbaram — Thu, 05 Dec 2019 08:00:10 GMT

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';

Re: Dimension is not selectable within in list

owhittle — Thu, 05 Dec 2019 08:32:11 GMT

Thank you, that worked.

Re: Dimension is not selectable within in list

lironbaram — Thu, 05 Dec 2019 08:37:33 GMT

great ,

always happy to land a helping hand