Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

How to Replace List Box Value for the User ?

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.

8 Replies
Highlighted
MVP
MVP

Re: How to Replace List Box Value for the User ?

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

Highlighted
Employee
Employee

Re: How to Replace List Box Value for the User ?

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

Highlighted
Not applicable

Re: How to Replace List Box Value for the User ?

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 ?

Highlighted
MVP
MVP

Re: How to Replace List Box Value for the User ?

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

Highlighted
Not applicable

Re: How to Replace List Box Value for the User ?

Thanks it works.

Highlighted
MVP
MVP

Re: How to Replace List Box Value for the User ?

Kindly close this question by selecting appropriate answer...

Highlighted
Not applicable

Re: How to Replace List Box Value for the User ?

how to close question and mark that as answer ?

Highlighted
MVP
MVP

Re: How to Replace List Box Value for the User ?

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

Untitled.png