topic Re: replace inside Variable in QlikView https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459261#M171419 <HTML><HEAD></HEAD><BODY><P>Thank for reply.</P><P>I tried it.</P><P>In list box it shows A, B and ''.</P><P>How can I hide ''?</P><P>Regards,</P></BODY></HTML> Fri, 25 Jan 2013 19:21:47 GMT Anonymous 2013-01-25T19:21:47Z replace inside Variable https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459259#M171417 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have variables</P><P>.<IMG __jive_id="32190" class="jive-image" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/32190_Capture.JPG" /></P><P>In Var 2 I need to replace A to '', if Var1=cc in script. Var 2 should be A and B</P></BODY></HTML> Fri, 25 Jan 2013 19:12:29 GMT https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459259#M171417 Anonymous 2013-01-25T19:12:29Z Re: replace inside Variable https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459260#M171418 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Load Var1,Var3</P><P> If(Var1 = 'cc','',Var2) as Var2</P><P>from tablename; //filename.xls</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 25 Jan 2013 19:16:43 GMT https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459260#M171418 MayilVahanan 2013-01-25T19:16:43Z Re: replace inside Variable https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459261#M171419 <HTML><HEAD></HEAD><BODY><P>Thank for reply.</P><P>I tried it.</P><P>In list box it shows A, B and ''.</P><P>How can I hide ''?</P><P>Regards,</P></BODY></HTML> Fri, 25 Jan 2013 19:21:47 GMT https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459261#M171419 Anonymous 2013-01-25T19:21:47Z Re: replace inside Variable https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459262#M171420 <HTML><HEAD></HEAD><BODY><P>I get it.</P><P>In list box expression</P><P>IF(Var1&lt;&gt;'cc', Var2)</P></BODY></HTML> Fri, 25 Jan 2013 19:29:20 GMT https://community.qlik.com/t5/QlikView/replace-inside-Variable/m-p/459262#M171420 Anonymous 2013-01-25T19:29:20Z