Expressions in variables

[#1]

Hi!

I'm trying to store QV expressions in variables using Excel and a loop in the QV-script that looks like this:

for i = 0 to NoOfRows('expressions') - 1

  let vName = peek('variablename', i, 'expressions'); // Name of the variable

  let $(vName) = peek('Formula', i, 'expressions'); // Expression

next i

And this works perfectly. It generates a number of variables containing expressions. The problem I have is that the variables I have are supposed to be in the same expression in QlikView.

So lets say that I have a variable called 'v1', to calculate this my expression would be $(v1) and it will execute the expression inside the variable.

But how do I do this for all my variables? Every variable is connected to a dimension in the table. So if I create a new variable which just says 'variablename' and put this in an expression in my table, my table will look like this:

So I get my name of the right variable but I can't calculate the right variable.

Hope you understand my problem. Any suggestions on what to do?

[swuehl]

I think you need to look at your 99 expressions and optimize those (or at least the ones that create the heavy load).