Qlik Community

Qlik Sense App Development

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

Not applicable

How can I obtain a field by 'name' in the charting side?

I want to make a metric selector in QlikSense so the average of the selected metric is displayed.

I am able to construct such a selector using the variable extension:

GitHub - erikwett/qsVariable: Variable extension for Qlik Sense

However, this extension requires to input all selectable values manually.

My idea is to use the FieldUI extension  GitHub - balexbyrd/sense-FieldUI: Bootstrap Radio, Checklist, Dropdown, and Buttons for a Dimension.... to construct a radio selector. With that radio selector, I can obtain the name of the metric, but, I am unable to retrieve the field using the obtained string.


I tried FieldValue function and FieldValueCount, but the first obtains only specific values and the later returns the number of unique values.

How can I obtain a whole field in the charting side without relying on a variable?


I include a simplified example of my problem.

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: How can I obtain a field by 'name' in the charting side?

Try below

=AVG($(=Top(METRIC)))

3 Replies
vinieme12
Esteemed Contributor II

Re: How can I obtain a field by 'name' in the charting side?

Try below

=AVG($(=Top(METRIC)))

vinieme12
Esteemed Contributor II

Re: How can I obtain a field by 'name' in the charting side?

or create a variable

vSelectedMetric

= Top(METRIC)

Expression in Textbox

AVG($(=vSelectedMetric))

Not applicable

Re: How can I obtain a field by 'name' in the charting side?

Works like a charm, thanks a lot.