topic Re: Getting Last Selected Value from a List Box in QlikView

Getting Last Selected Value from a List Box

gsbeaton — Thu, 23 Jun 2011 13:50:34 GMT

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

Getting Last Selected Value from a List Box

Thu, 23 Jun 2011 13:54:05 GMT

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.

Re: Getting Last Selected Value from a List Box

gsbeaton — Thu, 23 Jun 2011 14:02:25 GMT

Thank you NMiller - MaxString() worked fine!