Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
aerfurt85
New Contributor

Evaluate formula in script or application

Is it possible to evaluate a formula/function in a script or application?

For example:

Script

Tab1:

LOAD * INLINE [

    ReceiptDate, Formula

    "10.06.15", "AddMonth(ReceiptDate,1)"

    "12.06.15", "AddMonth(MonthStart(ReceiptDate),1)"

    "07.07.15", "date(ReceiptDate+ 15)"

];

Tab2:

LOAD ReceiptDate,

  Evaluate(Formula) as DueDate

Resident Tab1;

--------------------------------------------------------------------------------------------

Application

vDueDate (Variable):

TEST1: $(=Formula)

TEST2: $(Formula)

TEST3: $('$(=Formula)')

The Result is NULL or error.

---------------------------------------------------------------------------------------------

Any other ideas?

Thanks!

1 Reply
MVP
MVP

Re: Evaluate formula in script or application

Try one of the approaches discussed here:

Inside field calculation?

Community Browser