Discussion board where members can get started with QlikView.
I am new to qlikview.
I have below issue.
I have a list box which has value 0 and 1.
currently, 0 and 1 shows in the list box.
I would like to replace 0 with No and 1 with Yes for the user display.
how can we display and replace 0 and 1 with No and Yes for user selection ?
Considering your list box field name is VALUE...
Instead of VALUE as a Field use expression as below in List Box
IF(VALUE = 0, 'No','Yes')
Another option is under the script, you can set up below line...
IF(VALUE = 0, 'No','Yes') as ValueFlag,
Now use this ValueFlag as List Box Field
Thanks for your response.
Now, List box shows both values as below.
i would like to shows only No and Yes ?
how can we remove 0 and 1 from list box values ?
You have selected VALUE as a Field and written my expression under expression tab...
what actually you have to do is instead of VALUE as a Field choose <Expression> under General >> Field Tab..
Now write the Expression given above...
Hope this helps..
Whoever's answer you think is helpful or correct, select appropriate one...
You can select one correct and maximum two helpful answers...
Below type of two buttons you can see for each reply on your post.
Please select for all your pending threads wherever you think answers as already received but your haven't closed the thread. Many users are trying to find out solution of similar type of questions and Correct Answer marked can encourge them to read the thread...
Hope this helps...