How to Replace List Box Value for the User ?

[#1]

Hi all,

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 ?

Thanks.

[MK_QSL]

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

[JonnyPoole]

You can use a conditional expression as a source for the list box. Take a look at attached images

[#4]

Thanks for your response.

Now, List box shows both values as below.

0    No

1    Yes

i would like to shows only No and Yes ?

how can we remove 0 and 1 from list box values ?

[MK_QSL]

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..

[#6]

Thanks it works.

[MK_QSL]

Kindly close this question by selecting appropriate answer...

[#8]

how to close question and mark that as answer ?

[MK_QSL]

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...