How to reference a column with a calculated column name?

[#1]

Dear fellow Qlikview users,

In a report I am developing I would like to reference a column in an expression but this column has a calculated column label.

Can anybody tell me how to do this?

Detailed situation:

A report with 1 variable, v_cur_year which is set to 2009.

I have a table which has a dimension of product.
This table has a couple of expressions;

1. Label: = S2007
   Expression: = If( [subscription_year] = v_cur_year-2, 1)
2. Label: = S2008
   Expression: = If( [subscription_year] = v_cur_year-1, 1)
3. Label: Growth Last Year
   Expression: = [S2007] / [S2008]

Now what I want to do is to calculate the labels of the first two expressions by using my v_cur_year and subtracting 2 or 1. But how do I reference these columns in my [Growth Last Year] expression?

Hope that this explains my situation clearly and that the community can offer me some help.

Regards,

Mike van der Niet

[#2]

Mike try to take you variable v_cur_year in the expression using

$(v_cur_year) and it should work for Ex

[Gross Value Year] - $(v_cur_year)

If did not work then try to upload one dummy scenario

Talha

[#3]

Talha, I know how to use a variable in my expressions, this is not the problem.

What I want to know is, how do I reference another column in my expression if that column has a calculated label?

[hector]

hi, maybe you can resolve that changing Growth Last Year = column(1) / column(2) instead the labels?

rgds