Unable to sort chart by Date field (or any other other field except TEXT type)

[imtiaz_ullah]

Hi all,

I am test-driving QlikView PE and am having a really odd issue for something so basic.

I am trying to sort a chart on date and as I am returning month name in my axis I am sorting on EXPRESSION which is my DateTime field coming back from SQL Server as a DATETIME.

The chart refuses to sort by this or any other 'sort by' option, other than TEXT, at which point it sorts A-Z and Z-A without issue.

Am I missing the point here somewhere?

Thanks Immy

[rubenmarin]

Hi Immy, probably is messing when qv finds more than one date for a month, you can try with:

Month(Min({1} MessageDate))

This way, when QV found more than one date in a month it will get only one date and can calculate the month for that single date.