topic Re: How to Replace List Box Value for the User ? in QlikView https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719189#M1074362 <HTML><HEAD></HEAD><BODY><P>Thanks it works.</P></BODY></HTML> Tue, 05 Aug 2014 15:45:15 GMT 2014-08-05T15:45:15Z How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719184#M1074357 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am new to qlikview.</P><P></P><P>I have below issue.</P><P></P><P>I have a list box which has value 0 and 1.</P><P></P><P>currently, 0 and 1 shows in the list box.</P><P></P><P>I would like to replace 0 with No and 1 with Yes for the user display.</P><P></P><P>how can we display and replace 0 and 1 with No and Yes for user selection ?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 05 Aug 2014 15:19:20 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719184#M1074357 2014-08-05T15:19:20Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719185#M1074358 <HTML><HEAD></HEAD><BODY><P>Considering your list box field name is VALUE...</P><P>Instead of VALUE as a Field use expression as below in List Box</P><P></P><P>IF(VALUE = 0, 'No','Yes')</P><P></P><P>Another option is under the script, you can set up below line...</P><P></P><P>IF(VALUE = 0, 'No','Yes') as ValueFlag,</P><P></P><P>Now use this ValueFlag as List Box Field</P></BODY></HTML> Tue, 05 Aug 2014 15:29:48 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719185#M1074358 MK_QSL 2014-08-05T15:29:48Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719186#M1074359 <HTML><HEAD></HEAD><BODY><P>You can use a conditional expression as a source for the list box. Take a look at attached images</P></BODY></HTML> Tue, 05 Aug 2014 15:30:43 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719186#M1074359 JonnyPoole 2014-08-05T15:30:43Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719187#M1074360 <HTML><HEAD></HEAD><BODY><P>Thanks for your response.</P><P></P><P>Now, List box shows both values as below.</P><P></P><P>0&nbsp;&nbsp;&nbsp; No</P><P>1&nbsp;&nbsp;&nbsp; Yes</P><P></P><P>i would like to shows only No and Yes ?</P><P></P><P>how can we remove 0 and 1 from list box values ?</P></BODY></HTML> Tue, 05 Aug 2014 15:34:42 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719187#M1074360 2014-08-05T15:34:42Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719188#M1074361 <HTML><HEAD></HEAD><BODY><P>You have selected VALUE as a Field and written my expression under expression tab...</P><P>what actually you have to do is instead of VALUE as a Field choose &lt;Expression&gt; under General &gt;&gt; Field Tab..</P><P>Now write the Expression given above...</P><P>Hope this helps..</P></BODY></HTML> Tue, 05 Aug 2014 15:40:13 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719188#M1074361 MK_QSL 2014-08-05T15:40:13Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719189#M1074362 <HTML><HEAD></HEAD><BODY><P>Thanks it works.</P></BODY></HTML> Tue, 05 Aug 2014 15:45:15 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719189#M1074362 2014-08-05T15:45:15Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719190#M1074363 <HTML><HEAD></HEAD><BODY><P>Kindly close this question by selecting appropriate answer...</P></BODY></HTML> Tue, 05 Aug 2014 15:53:46 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719190#M1074363 MK_QSL 2014-08-05T15:53:46Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719191#M1074364 <HTML><HEAD></HEAD><BODY><P>how to close question and mark that as answer ?</P></BODY></HTML> Tue, 05 Aug 2014 16:06:20 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719191#M1074364 2014-08-05T16:06:20Z Re: How to Replace List Box Value for the User ? https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719192#M1074365 <HTML><HEAD></HEAD><BODY><P>Whoever's answer you think is helpful or correct, select appropriate one...</P><P>You can select one correct and maximum two helpful answers... </P><P>Below type of two buttons you can see for each reply on your post.</P><P></P><P>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...</P><P></P><P>Hope this helps...</P><P><IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63781_Untitled.png" style="width: 620px; height: 230px;" /></P></BODY></HTML> Tue, 05 Aug 2014 18:24:28 GMT https://community.qlik.com/t5/QlikView/How-to-Replace-List-Box-Value-for-the-User/m-p/719192#M1074365 MK_QSL 2014-08-05T18:24:28Z