topic Evaluate a stored formula in script in QlikView

Evaluate a stored formula in script

Mon, 03 Sep 2012 16:59:05 GMT

Hello,

I've 2 tables that are stored in QVD's

definition table: the id's, for what I must calculate the formula written in the field "formula"
values tables: the values needed to calculate the formula

I would like to create a script and get the calculations with help of the values tables directly in script. That means that I must find a way to evaluate the Formula. Does anybody have an idea on how to do that ? Do I think in the false direction ?

As a result, I simply would like that:

DepID_1008 --> 40 - 66 = -26
DepID_1009 --> 40 - 66 + 55 = 29

Thanks,

Ivan

Re: Is that possible with a set analysis ?

Jason_Michaelides — Mon, 03 Sep 2012 22:17:47 GMT

FI4030 - FI4027 = -26, not 5 so how do you get your desired results?

Re: Is that possible with a set analysis ?

Thu, 06 Sep 2012 16:49:16 GMT

Okay,

I've found, I can do that in script with the evaluate() function.

Regards,

Ivan