topic Evaluate dynamic variables in table in QlikView

Evaluate dynamic variables in table

dinnoroni — Fri, 19 Mar 2021 10:29:18 GMT

Hi I have an island table as the following

id	var	exp
1	vMetric1	Sum(A)
2	vMetric2	Sum(B)
3	vMetric3	Sum(A)*Sum(B)
4	vMetric4	Sum(A)/Sum(B)

in my scripts, I loop through the table build out variables dynamically.

In the dashboard I creating a table using id as the dimension and Maxtstring(var) is my expression. How can I evaluate the variables and get the value?

Re: Evaluate dynamic variables in table

marcus_sommer — Fri, 19 Mar 2021 11:56:15 GMT

It's not possible because within the UI is no classical evaluate() available. The only exception is a $-sign expansion but it creates an ad-hoc variable which has always a single global value which is evaluated at first and then applied to all rows / columns - means you couldn't apply it within a dimensional context.

- Marcus