Expressions for column labels in chart

rudywelvaert — Wed, 19 Aug 2015 14:25:57 GMT

Hi,

Using a translation table I want to change the labels of the columns in a chart according the chose language.

For example:

Translate:

Load * inline

[

Field,Dutch,French, English

AXB_NR,Nummer, Numero, Number

TMSS_BDR,Bedrag, Montant, Amount

CAP_NM,Naam, Nom, Name

];

The language is stored in the variable vLanguage, namely: Dutch,French or English

I translate the individual labels of the columns in the chart in this way:

=FieldValue($(vLanguage), FieldIndex('Field','AXB_NR')) --> label for column AXB_NR in the language in vLanguage

=FieldValue($(vLanguage), FieldIndex('Field','TMSS_BDR')) --> label for column TMSS_BDR in the language in vLanguage

=FieldValue($(vLanguage), FieldIndex('Field','CAP_NM')) --> label for column CAP_NM in the language in vLanguage

but it would be practical that I don't have to refer to the column name literally , but use a sort of variable $ThisColumnName

For every label I could use the same expression:

=FieldValue($(vLanguage), FieldIndex('Field',$ThisColumnName))

Is this possible?

Thanks

topic Expressions for column labels in chart in QlikView