Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

Try below

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
vinieme12
Champion III
Champion III

Try below

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

or create a variable

vSelectedMetric

= Top(METRIC)

Expression in Textbox

AVG($(=vSelectedMetric))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Works like a charm, thanks a lot.