topic Re: Dynamically calculate /apply Formula to field (SCRIPT) in QlikView

Dynamically calculate /apply Formula to field (SCRIPT)

Sat, 11 Apr 2015 13:32:12 GMT

Hi Guys,

The table below:

Components14:

LOAD

_ComponentKey2

,KPI_Formula_byComponent

,61

,62

,65

,66

FROM $(vModified)Components15.qvd (qvd);

as the following values:

_ComponentKey2	KPI_Formula_byComponent	61	65	62	66
26 . -1 . 6 . 20150301	(61/65) + (62/66)	61	65	62	66

I need to create a new field containing the RESULT of the formula in field "KPI_Formula_byComponent". Please note the formula may change and I need to "follow" the changes dynamically.

Using the following the issue is solved!

,Evaluate(KPI_Formula_byComponent) AS Calculated_KPI

Aldo.

Message was edited by: Aldo Liaks Solved.

Re: Dynamically calculate /apply Formula to field (SCRIPT)

MK_QSL — Sat, 11 Apr 2015 13:53:33 GMT

You can use preceding load as below;

================================================

Components14:

Load

(61/65) + (62/66) as KPI_Formula_byComponent;

LOAD

_ComponentKey2

,YourExpression as 61

,YourExpression as 62

,YourExpression as 65

,YourExpression as 66

FROM $(vModified)Components15.qvd (qvd);

Re: Dynamically calculate /apply Formula to field (SCRIPT)

Sat, 11 Apr 2015 14:01:46 GMT

Hi,

Thanks for your answer.

The function "Evaluate" solves the issue.

,Evaluate(KPI_Formula_byComponent) AS Calculated_KPI

Aldo.