display on a current Selection Object

[josephinetedesc]

Hi I have a list box which shows the months - I used an expression:

=Monthname(date(dateQA))

When I thing choose a month from this list box - the Current Selections box show the selection as 623 of 4380 o r 618 or 4380 etc

Is there something I can do about this?  It is correct but users are thrown off by the fact that it is not showing what they selected ie May 2016.

Thank you

o\Jo

[tamilarasu]

Hi Josephine,

Follow the below steps.

Menù -> User preferences --> General -> Max Values in Current Selections -> Max limit is 100 (Distinct values will be shown in current selection box).

[josephinetedesc]

Sorry Tamil I have not explained myself well:

the list box shows the Months in the format of Apr 2016 but the selection box does not show Apr 2016 it will show 208 of 3043.  208 of 3043 are the number of individual dates in April 2016.

So in the original document dateQA is a datestamp (there are 3043 dates in this instance) - in the Lilstbox - the datestamps are grouped according to the monthname - so for example in April - there were 208 dateQA datestamps and they are grouped under the monthname which is displayed.  The Selection box however does not show the monthname date group, but tells me that I have 208 dates.  Hope that makes sense.

Jo. 

[vishsaggi]

May be create a new field in your script like

Load col1,

        col2,

        dateQA,

        date(monthstart(DateQA), 'MMM-YYYY') as MonthYear

FROM ...... ;

And create MonthYear listbox.

Just a thought!!!

V.

[josephinetedesc]

[josephinetedesc]

This is what I mean - the list box is fine (showing the edited expression), but the Current Selections box is confusing - although correct.

[tamilarasu]

Hi Josephine,

As mentioned by Vishaggi, create a new field in back end and use the field name in listbox.

[NZFei]

The current selection box is showing the current selections by fields. The only field that you have selected is dateQA so it only shows dateQA. If you create a field called "MonthName" in the script and then make selection in the front in this field, it will show May 2016 in the current selection box.

The calculation "=Monthname(date(dateQA))" is not a field.

Hope that can help.

Fei

[josephinetedesc]

Thank you