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?
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.