Dynamic Chart Expression to use Variable name

Fri, 03 Aug 2012 14:41:29 GMT

A rather strange straight table is requested with given names for rows. The expressions for the individual rows have their indvidual evaluations.

I have created an Excel sheet with the RowName, the VariableName and the Expression for each row.

e.g.

RowName,VariableName,Expression

R1, V1, sum(x)

R2, V2, sum(y)

I load the Excel data and create Variables for each of the Expressions given. (e.g. V1 is shown as "sum(x)" in the variables list)

Then I thought I would load the Row Names and Variable Names into a new table ...

MyTable: LOAD

RowName, VariableName

from "excelsheet"

So the table looks like

RowName, VariableName

R1, V1

R2, V2

and for the display create a straight table with Dimension set to RowName and for the Expression I thought I could use

evaluate(VariableName)

but bad luck - function can not be used in chart expressions!

How would a QVPro solve such a situation?

Thanks, Jürg

topic Dynamic Chart Expression to use Variable name in QlikView