Dynnamic field selecton

[#1]

Hello everyone,

I would like to know if it's possible to interpret a field name originally stored as a test variable.

Here is a small exemple :

1) I have a table which contains data necessary to my controls

Items            Limit      Target_Field

Items I          >0          T_Value

Items II          =0         T_Qty

2) I load this table and now, I would like to interpret 'Target_Field' as 'real field' and not as a text value in expression. Basically, here one exemple of what I would like to do in my expression input box into a basic pivot :

Sum(If(T_Items=Items,Target_Field) <= Where "Target_Field" is interpreted as a field name

So, I hope I was clear !

Thank you.

BR.

[#2]

Julian,

use the $ expansion: it interprets your variable

so I would do: '$(Target_Field)' or sth like $(=Target_Field)

But I think it should have one single value: it cannot be dimensionned

Fabrice

[#3]

Yes, indeed it's a single colum control.

[#4]

See the excellent post by HIC about $ expansion (interpretation of variables):

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions

Fabrice