Getting Last Selected Value from a List Box

[gsbeaton]

Hi Fellow Qlikers,

Does anyone know of a function to get the last selected value (Max value would work too) from a list box.  In the example in the the attached picture, I want to get 05 (Dec).   Alternatively, I have another data set, where I can rank months numnbericaly, so getting the Max selected number would also work.

Thanks for your help

George

[#2 · Accepted solution]

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.

[gsbeaton]

Thank you NMiller - MaxString() worked fine!