topic Problem with Month Sort in QlikView

Problem with Month Sort

Mon, 23 May 2011 13:41:57 GMT

Hi,

I've a problem with a list containing months.

This list displays Abbreviated Months (MONTH_ABREV) and is sorted by the Month code (MONTH_CD).

The problem is :

When i select one or several months, the selection moves at the end and the sort becomes wrong (see picture before and after selection below)!

This worked last week but not yet. I think i touched an option but which?

Thanks,

Greg

prieper — Mon, 23 May 2011 13:51:39 GMT

Under Properties -> Sort you have various options to change the display and sorting of dimensions in a listbox.

Most likely you have selected descending under "State".

HTH
Peter

yasus — Mon, 23 May 2011 13:55:26 GMT

Try the following:

erichshiino — Mon, 23 May 2011 13:59:03 GMT

I'd say you should use only the checkbox of numeric value

Regards,

Erich

Mon, 23 May 2011 14:07:43 GMT

Hi,

thanks for your reply.

in fact, it's a QlikView bug.

I just changed the field MONTH_ABREV by MONTH_CD, applied the changes.

After, I changed MONTH_CD by MONTH_ABREV (to come back to the initial situation) and it works :-s

The problem is "Why?"...

Thanks again.

Greg