topic Re: Dynnamic field selecton in QlikView

Dynnamic field selecton

Thu, 21 Nov 2013 07:27:15 GMT

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.

Re: Dynnamic field selecton

Thu, 21 Nov 2013 08:13:59 GMT

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

Re: Dynnamic field selecton

Thu, 21 Nov 2013 08:17:17 GMT

Yes, indeed it's a single colum control.

Re: Dynnamic field selecton

Thu, 21 Nov 2013 08:20:59 GMT

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

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

Fabrice