topic help in QlikView https://community.qlik.com/t5/QlikView/help/m-p/905445#M1014345 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>can we change special charcters(#,@,*) to numbers(100,200,300) in qvw existing table?</P><P>I tried inputfield then it works fine but while am using combination of pick and match functions but it doesn't work.</P><P></P><P>am looking for any other ideas</P><P></P><P>Please have a look at this issue.</P><P></P><P>Rgs</P><P>satish</P></BODY></HTML> Sat, 25 Apr 2015 13:55:05 GMT 2015-04-25T13:55:05Z help https://community.qlik.com/t5/QlikView/help/m-p/905445#M1014345 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>can we change special charcters(#,@,*) to numbers(100,200,300) in qvw existing table?</P><P>I tried inputfield then it works fine but while am using combination of pick and match functions but it doesn't work.</P><P></P><P>am looking for any other ideas</P><P></P><P>Please have a look at this issue.</P><P></P><P>Rgs</P><P>satish</P></BODY></HTML> Sat, 25 Apr 2015 13:55:05 GMT https://community.qlik.com/t5/QlikView/help/m-p/905445#M1014345 2015-04-25T13:55:05Z Re: help https://community.qlik.com/t5/QlikView/help/m-p/905446#M1014346 <HTML><HEAD></HEAD><BODY><P>Hi Satish,</P><P></P><P>Pick match should work. Try this expression</P><P></P><P><SPAN style="color: #0433ff;">pick</SPAN>(<SPAN style="color: #0433ff;">match</SPAN>(<SPAN style="color: #941100;">incr</SPAN>,'#','@','*',<SPAN style="color: #941100;">incr</SPAN>),100,200,300,<SPAN style="color: #941100;">incr</SPAN>)</P><P></P><P>Hope it work!</P><P></P><P>Regards</P><P></P><P>Sana</P></BODY></HTML> Mon, 27 Apr 2015 06:56:40 GMT https://community.qlik.com/t5/QlikView/help/m-p/905446#M1014346 2015-04-27T06:56:40Z