topic Variable concatenated with $ not evaluating in QlikView

Variable concatenated with $ not evaluating

Fri, 16 Dec 2011 16:43:53 GMT

I have created a table that includes metric names and metric variables (set as formulas) for two groups. In an expression in a straight table, the variable (which includes parentheses) is returned and I am concatenating it with a dollar sign. My hope was that this would force dollar sign expansion of the variable, but it isn't evaluating. Can anyone give me some advice on how to make this happen.

See qwv attached. First Expression is the field from the table that contains the variables (see Inline Load in CALCs tab in load script). Second Expression is the field (variable) concatenated with a dollar sign at the front. The Fourth Expression is what the result should be for Group 1.

Thanks in advance!

Variable concatenated with $ not evaluating

Mon, 19 Dec 2011 13:49:18 GMT

bump!

Re: Variable concatenated with $ not evaluating

jagan — Mon, 19 Dec 2011 14:20:55 GMT

Hi,

Please find the attached file.

Hope this helps you.

Regards,

Jagan.

Variable concatenated with $ not evaluating

rwunderlich — Mon, 19 Dec 2011 17:40:02 GMT

You can't force evaluation that way. Would be nice, but as you found you get just a string with a $ in it.

The way I've approached this problem is with a pick(match()) expression.

=pick(

match(Vg1Metric

, 'Vg1Head'

,'Vg1Liv'

)

, '$(Vg1Head)

, $(Vg1Liv)

)

-Rob

Variable concatenated with $ not evaluating

Mon, 19 Dec 2011 18:21:19 GMT

Thank you, Rob! This approach will work.