topic Re: List Box Expression in QlikView https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759259#M1034765 <HTML><HEAD></HEAD><BODY><P>Thank you Tresesco.</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Fri, 09 Jan 2015 07:20:19 GMT krishna20 2015-01-09T07:20:19Z List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759257#M1034763 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I'm having a field like TP_Type which having values POL, REN,END. I need to show these values as Policy , Renewal, Endorsement in list Box. How can i write an expression to achieve it.Please ,someone suggest to do it.</P><P></P><P>Thanks in Advance</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Fri, 09 Jan 2015 07:09:57 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759257#M1034763 krishna20 2015-01-09T07:09:57Z Re: List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759258#M1034764 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>Pick(Match(TP_Type, 'POL', 'REN', 'END'), 'Policy', 'Renewal', 'Endorsement')</P></BODY></HTML> Fri, 09 Jan 2015 07:17:56 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759258#M1034764 tresB 2015-01-09T07:17:56Z Re: List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759259#M1034765 <HTML><HEAD></HEAD><BODY><P>Thank you Tresesco.</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Fri, 09 Jan 2015 07:20:19 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/759259#M1034765 krishna20 2015-01-09T07:20:19Z