Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search and replace values in script

Hello,

I've the following 2 tables. What I wan to do is the following:

  • search the values in the left table and replace them in the formula in the right table (no idea on how to proceed)
  • evaluate the formula (I know how to do that, with the evaluate() function)

I must do that in the script!

Unbenannt.PNG

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 ?

Thanks!

IP

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you for your help. I must now search how to do this dynamically.

Regards,

IP