Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you NMiller - MaxString() worked fine!