Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
owhittle
Contributor
Contributor

Dimension is not selectable within in list

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

chart.PNGtable.PNG

Labels (4)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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

 

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Contributor
Contributor
Author

Thank you, that worked.

lironbaram
Partner - Master III
Partner - Master III

great , 

always happy to land a helping hand