topic Re: Evaluate Variable in Formula String in Table Field in QlikView

Evaluate Variable in Formula String in Table Field

hugmarcel — Fri, 23 Jan 2015 14:51:47 GMT

1.) I have Table Field T.X with string value: "INTERVAL($(TalkTime)/(60*60*24),'hh:mm:ss')"
2.) Variable TalkTime has content: "Sum([TALK.Time])"

Goal is to create new Field T.Y having content: "INTERVAL(Sum([TALK.Time])/(60*60*24),'hh:mm:ss')",
using a Script function during load.

Any idea?

Thank you! Marcel

Re: Evaluate Variable in Formula String in Table Field

marcus_sommer — Fri, 23 Jan 2015 16:21:27 GMT

I think you will need to pick these field-content per peek(), lookup() or fieldvalue() into a variable and used then these variable in your load, maybe like this:

...

let exp = peek('T.X', 0, 'expTable');

t1:

Load *, $(exp) as newField From xyz;

....

- Marcus