Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gsbeaton
Contributor II

Getting Last Selected Value from a List Box

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

Georgelast_value.png

1 Solution

Accepted Solutions
Not applicable

Getting Last Selected Value from a List Box

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.

2 Replies
Not applicable

Getting Last Selected Value from a List Box

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
Contributor II

Re: Getting Last Selected Value from a List Box

Thank you NMiller - MaxString() worked fine!

Community Browser