I want to Use a field name which is dynamic for the value of a chart, such as I want the Value of the field

[#1]

I want to Use a field name which is dynamic for the value of a chart, such as I want the Value of the field which is made up of a string constant 'Support' plus whatever is the depth for the row which is stored in the depth field.  So Support + Depth whch could equal Support7 for one row and Support 10 for another.. How do I do that?

[Nicole-Smith]

='Support' & [Depth]

[#3]

I want the value of the filed with Support + Depth

[Nicole-Smith]

Can you attach a sample .qvw?

[Anonymous]

Chris

Use the expression Nicole suggested as a Calculated Dimension in your Chart.

Best Regards,     Bill

[Gysbert_Wassenaar]

See attached example. It uses the values of two fields instead of a string + a field value, but that should give you enough information.

[swuehl]

Depth is your dimension?

This isn't possible, the expression can't be set per dimension. You can however use a single expression that checks the current dimension value:

=pick(Depth,

Support1,

Support2,

Support3,

Support4

)

[Nicole-Smith]

If I understand what you're asking for, make a variable and set it's value to (for an example, let us say I create a variable named vVariable):

'[Support'&[Depth]&']'

Then, where you want to use the variable:

=$(=$(vVariable))

[#9]

Try

"Support$(=only(Depth))"