Use GetFieldsSelection in Aggregations

[Anonymous]

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

[tyagishaila]

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]

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

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

[Anonymous]

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.