Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adress field with variable

Hey everyone!

I have a question regarding a variable in a set expression.

My data structure is as follows: I have one table with KPIs per year per unit.

I have another table for the localisation of the app: It consists of one Expression_Id and a column for each language, f.e.

Expression_ID         de-de                              en-us

Equity ratio               Eigenkapitalquote          Equity Ratio,

where the Expression_Id equals the English version of the KPI name for the code to be understood much more easily.

Depending on a selection on language, I want QlikSense to show the name of the KPI from the column containing the name in the selected language. F.e. if the selected Language is de-de, QlikSense should show the German name of the KPI identified by the expression_ID from the column de-de.

I have one variable, vLanguage (=Getfieldselections(Language).

To get the KPI name in the desired language, I use the following expression:

Only({$<Expression_ID={Equity ratio}>}$(vLanguage)),

which return only the name of the selected language, but does not address the column in the language table whose name equals the selected language.

Can somebody please advise how to address columns/fields based on variables?

Thanks in advance!

Kathy

5 Replies
sunny_talwar

May be try this

Only({$<Expression_ID={Equity ratio}>} $(=Language))

Note, I am not using vLanguage (your variable), but Language, you field name... I am assuming that one value will always be selected in this field (either English or German)

Not applicable
Author

Hi Sunny,

thank you so much for your answer. I tried your Suggestion, but it does not work either. The Output is either '-' or the Name of the language (f.e. de-de), depending on my usage of Quotation marks & parentheses...

sunny_talwar

depends on your usage or Quotation marks and parentheses? Can you elaborate on this?

Not applicable
Author

Hi Sunny,

if I use it as you suggested I get "-", if I put parentheses around I get "de-de", which is the value of my variable. Both are not the desired Output, as I would like to address a field that is named as the variable.

Is there any solution to this?

I find it hard to imagine that no one else has ever addressed a field based on a variable.

Thanks!

Not applicable
Author

A post from another user helped me to address the question. Using set Analysis did not work for me here, but this function:

FieldValue($(vLanguage), FieldIndex('Expression_ID', 'Equity ratio'))