topic Re: Search and replace values in script in QlikView https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400890#M149180 <HTML><HEAD></HEAD><BODY><P>Thank you for your help. I must now search how to do this dynamically.</P><P></P><P>Regards,</P><P></P><P>IP</P></BODY></HTML> Tue, 18 Sep 2012 10:08:46 GMT 2012-09-18T10:08:46Z Search and replace values in script https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400888#M149178 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've the following 2 tables. What I wan to do is the following:</P><UL><LI>search the values in the left table and replace them in the formula in the right table (no idea on how to proceed)</LI><LI>evaluate the formula (I know how to do that, with the evaluate() function)</LI></UL><P></P><P><STRONG>I must do that in the script!</STRONG></P><P><IMG __jive_id="21707" class="jive-image-thumbnail jive-image" onclick="" alt="Unbenannt.PNG" src="https://community.qlik.com/legacyfs/online/21707_Unbenannt.PNG" width="450" /></P><P></P><P>Has anyone an idea or some useful functions ? It's clear that I will have to loop over the field Formula, but how to find the value in the left table ?</P><P></P><P>Thanks!</P><P></P><P></P><P>IP</P></BODY></HTML> Wed, 12 Sep 2012 12:42:45 GMT https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400888#M149178 2012-09-12T12:42:45Z Re: Search and replace values in script https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400889#M149179 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Fri, 14 Sep 2012 09:20:04 GMT https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400889#M149179 Gysbert_Wassenaar 2012-09-14T09:20:04Z Re: Search and replace values in script https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400890#M149180 <HTML><HEAD></HEAD><BODY><P>Thank you for your help. I must now search how to do this dynamically.</P><P></P><P>Regards,</P><P></P><P>IP</P></BODY></HTML> Tue, 18 Sep 2012 10:08:46 GMT https://community.qlik.com/t5/QlikView/Search-and-replace-values-in-script/m-p/400890#M149180 2012-09-18T10:08:46Z