Distinct selection in a List Object

Anonymous — Wed, 07 Mar 2012 16:24:30 GMT

I create a list with a date field from a table and I formated the list content to show only months "MMM".

The problem is that this field have several itens from the same month and I want to see only one copy of all valid months.

Like: select distinct month(datefield) from table

swuehl — Wed, 07 Mar 2012 17:10:16 GMT

You are using the number format tab in list box properties, right?

try using a list box field expression instead (on general tab, select <expression> from the field drop down) and enter:

=month(YOURDATEFIELD)

=Date(monthstart(YOURDATEFIELD),'MMM')

=monthname(YOURDATEFIELD)

You could also add a field to your table using

LOAD

...

YOURDATEFIELD,

month(YOURDATEFIELD) as Month

from Table;

and just use this field in the list box.

topic Distinct selection in a List Object in QlikView