topic Re: Evaluate formula in script or application in QlikView https://community.qlik.com/t5/QlikView/Evaluate-formula-in-script-or-application/m-p/882055#M655327 <HTML><HEAD></HEAD><BODY><P>Try one of the approaches discussed here:</P><P><A href="https://community.qlik.com/thread/38857">Inside field calculation?</A></P></BODY></HTML> Fri, 12 Jun 2015 11:50:54 GMT swuehl 2015-06-12T11:50:54Z Evaluate formula in script or application https://community.qlik.com/t5/QlikView/Evaluate-formula-in-script-or-application/m-p/882054#M655326 <HTML><HEAD></HEAD><BODY><P>Is it possible to evaluate a formula/function in a script or application?</P><P></P><P>For example:</P><P><STRONG>Script</STRONG></P><P></P><P>Tab1:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; ReceiptDate, Formula</P><P>&nbsp;&nbsp;&nbsp; "10.06.15", "AddMonth(<SPAN style="font-size: 13.3333330154419px;">ReceiptDate</SPAN>,1)"</P><P>&nbsp;&nbsp;&nbsp; "12.06.15", "AddMonth(MonthStart(<SPAN style="font-size: 13.3333330154419px;">ReceiptDate</SPAN>),1)"</P><P>&nbsp;&nbsp;&nbsp; "07.07.15", "date(<SPAN style="font-size: 13.3333330154419px;">ReceiptDate</SPAN>+ 15)"</P><P>];</P><P></P><P></P><P>Tab2:</P><P>LOAD <SPAN style="font-size: 13.3333330154419px;">ReceiptDate</SPAN>,</P><P>&nbsp; Evaluate(<SPAN style="font-size: 13.3333330154419px;">Formula</SPAN>) as DueDate</P><P>Resident Tab1;</P><P>--------------------------------------------------------------------------------------------</P><P>Application</P><P></P><P>vDueDate (Variable):</P><P>TEST1: $(=<SPAN style="font-size: 13.3333330154419px;">Formula</SPAN>)</P><P>TEST2: $(Formula)</P><P>TEST3: $('$(=Formula)')</P><P></P><P>The Result is NULL or error.</P><P>---------------------------------------------------------------------------------------------</P><P>Any other ideas?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 12 Jun 2015 11:43:20 GMT https://community.qlik.com/t5/QlikView/Evaluate-formula-in-script-or-application/m-p/882054#M655326 aerfurt85 2015-06-12T11:43:20Z Re: Evaluate formula in script or application https://community.qlik.com/t5/QlikView/Evaluate-formula-in-script-or-application/m-p/882055#M655327 <HTML><HEAD></HEAD><BODY><P>Try one of the approaches discussed here:</P><P><A href="https://community.qlik.com/thread/38857">Inside field calculation?</A></P></BODY></HTML> Fri, 12 Jun 2015 11:50:54 GMT https://community.qlik.com/t5/QlikView/Evaluate-formula-in-script-or-application/m-p/882055#M655327 swuehl 2015-06-12T11:50:54Z