Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

8 Replies
Nicole-Smith

='Support' & [Depth]

Not applicable
Author

I want the value of the filed with Support + Depth

Nicole-Smith

Can you attach a sample .qvw?

bill_markham

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.


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

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))

Not applicable
Author

Try

"Support$(=only(Depth))"