Change Field name in QV chart with formula

[diegomen]

Hallo,

in my projects I use a standard naming with prefix, for example T_YEAR, T_WEEK, etc. to distiguish misure, time fields, description fields, etc.

Now for some charts I must remove this prefix but I wouldn't rewrite the label for all fields so I'm finding a formula to make it.

It seems simple but I have a problem

=MID('C_AZIENDA',INDEX('C_AZIENDA','_',1)+1,100)

I do not have to write "C_AZIENDA" but I have to indicate "THE FIELD" because the formula, which should remain the same in all the fields, should satisfy the reference of the name of that field.

Is it possible?

Thank you,

Diego.

[vishsaggi]

You mean the values in the field C_AZIENDA or the Actual field itself? May be use subfield function like

= SubField('C_AZIENDA', '_',2)

[diegomen]

I mean the field label, not the content and I try to find a reference for this.

For example, [$ Fields] allows you to extract the list of fields but I need the reference of the field I am editing.

Thank you,

Diego.

[vishsaggi]

So it means individually in each dimension label you have to give the field name right? Or did misunderstood your requirement?

[rwunderlich]

Unfortueatly, there is no way I know of indirectly reference the current Field, like "this" or "self".  The function GetObjectField() would get you close, but that function returns null when used in Label expression.

-Rob

[diegomen]

Exactly, each dimension has a prefix and I must remove it to get only part of the label

[vishsaggi]

So you have to use Subfield function for each dimension label as a one time change. That is the only way.