topic Re: Change Field name in QV chart with formula in QlikView

Change Field name in QV chart with formula

diegomen — Tue, 28 Aug 2018 14:39:30 GMT

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.

Re: Change Field name in QV chart with formula

vishsaggi — Tue, 28 Aug 2018 15:23:11 GMT

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

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

Re: Change Field name in QV chart with formula

diegomen — Tue, 28 Aug 2018 15:32:29 GMT

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.

Re: Change Field name in QV chart with formula

vishsaggi — Tue, 28 Aug 2018 16:39:04 GMT

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

Re: Change Field name in QV chart with formula

rwunderlich — Tue, 28 Aug 2018 16:51:03 GMT

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

Re: Change Field name in QV chart with formula

diegomen — Wed, 29 Aug 2018 06:07:54 GMT

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

Re: Change Field name in QV chart with formula

vishsaggi — Wed, 29 Aug 2018 15:27:46 GMT

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