QlikView aggregation functions will be based on selections by default. Since your values are text, you may need: MaxString([Financial Period]). If there are no selections it will be the max in your dataset. If there are selections, it will be the max selected value. On your numerical field, Max(FIELD) should work.