Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mrsingingclub
Contributor
Contributor

Use GetFieldsSelection in Aggregations

Hello,

I would like to achieve the following in QlikView:

I have a list box "Parameter" listing all fields by using $Field. If I select one element from Parameter I would like to get min(), max(),avg() for that field in a text box. I tried something like: =max($(=GetFieldSelections($Field))) . But that does not work.

I just want to replace the literal field name by the selected value. How can this be done?

Thank you

12 Replies
tyagishaila
Specialist
Specialist

First, you create a variable for GetFieldSelections($field)

e.g.    vGetField

than use aggr function with this variable

e.g. Min($(vGetField))

Hope it will work!

tresesco
MVP
MVP

Try putting set analysis identifier {1} for global output, like :

=Max( {1} $(='['&getfieldSelections($Field)&']'))

mrsingingclub
Contributor
Contributor
Author

OK. I found the issue. Has nothing to do with this aggregation.

There is a date dimension that I use for the diagram as well as for the listbox. I have several values per day so the diagram and the list show only values if there is exactly one value per day otherwise nothing.

I have to figure out how display all values for each day. I think that is worth another thread.

Thank you all for your kind help.