Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
='Support' & [Depth]
I want the value of the filed with Support + Depth
Can you attach a sample .qvw?
Chris
Use the expression Nicole suggested as a Calculated Dimension in your Chart.
Best Regards, Bill
See attached example. It uses the values of two fields instead of a string + a field value, but that should give you enough information.
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
)
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))
Try
"Support$(=only(Depth))"