topic How to reference a column with a calculated column name? in QlikView

How to reference a column with a calculated column name?

Fri, 16 Oct 2009 23:34:26 GMT

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;

Label: = S2007
Expression: = If( [subscription_year] = v_cur_year-2, 1)
Label: = S2008
Expression: = If( [subscription_year] = v_cur_year-1, 1)
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

How to reference a column with a calculated column name?

Fri, 16 Oct 2009 23:59:52 GMT

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

How to reference a column with a calculated column name?

Sat, 17 Oct 2009 00:04:13 GMT

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?

How to reference a column with a calculated column name?

hector — Sat, 17 Oct 2009 00:34:50 GMT

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

rgds