topic Selecting First value in a List Box selection in QlikView

Selecting First value in a List Box selection

Wed, 04 Jun 2014 11:06:39 GMT

Hi All,

I have a case where a user can select more than one item in a list box. I want to use the first item selected in a chart. For example, if my list box is as shown below with the selections show, how can I extract POR1H14 as the Top item and use this in my chart? I've tried GetFieldSelections etc but am struggling on how to get the 'top' list item selected... All help much appreciated

John

Re: Selecting First value in a List Box selection

tresB — Wed, 04 Jun 2014 11:18:37 GMT

Try: =MinString([Forecast Version])

Chart Dimension: [Forecast Version], expression like: =Sum({< [Forecast Version] ={'$(=MinString([Forecast Version]))'}>} YourField)

Re: Selecting First value in a List Box selection

Wed, 04 Jun 2014 13:01:20 GMT

John,

you must take care to have the same sort order in listbox and your function. If values in listbox are sorted by its string value, it will be easy with maxstring or minstring. If there is some other field (for example with id), you may use FirstSortedValue().

regards

Darek