topic Re: Using a variable to hold part of a variable name to use in an expression in QlikView

Using a variable to hold part of a variable name to use in an expression

Tue, 11 Dec 2012 17:31:05 GMT

Hello

I have a set of numeric columns:

Buildings Incurred

Contents Incurred

Other Incurred

I have a variable called polsection and it contains the first part of the variable name, e.g. "Buildings", "Contents", "Other"

I want to write a table expression that joins this variable to a string to create the full variable name and sums the value of the field.

I've tried

=sum(=$(polsection)&' Incurred')

and

=sum([$(polsection)&' Incurred'])

and every other combination of symbols I can think of.

Is this even possible? If so how do I do it?

Many thanks!

Re: Using a variable to hold part of a variable name to use in an expression

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 17:38:31 GMT

Hi,

Yes, that should work, and you are very close:

Sum([$(polsection) Incurred])

Hope that helps.

Miguel

Re: Using a variable to hold part of a variable name to use in an expression

MayilVahanan — Tue, 11 Dec 2012 17:54:52 GMT

Try like this

variableName

its value ='Buildings'

Then in expression

Sum($(polsection) Incurred)

Ex:

PFA

Re: Using a variable to hold part of a variable name to use in an expression

Wed, 12 Dec 2012 14:00:16 GMT

Thanks Mayil

The only other issue is that I want the variable value (='Buildings', ='Contents', etc...) to be selectable in a list box. So I'm trying to use a trigger on list box selection to put the value into a variable, but I don't know how to put ='Buildings' into the variable.

Do you know how to do this?

Thanks.

Re: Using a variable to hold part of a variable name to use in an expression

Wed, 12 Dec 2012 18:51:52 GMT

Try the function Getfieldselection

For example variablename =GetFieldSelection (ListBoxName,',') in the Variable Overview..