topic date sort in QlikView

date sort

Fri, 23 Oct 2015 13:37:10 GMT

I am not able to sort this chart-

I have tried every possible option but not able to do

miguelbraga — Fri, 23 Oct 2015 14:03:28 GMT

Hi Sesa Stone,

How do you want to sort?

Regards,

sunny_talwar — Fri, 23 Oct 2015 14:07:11 GMT

try the following sort expression:

=Date#(YourDimensionName, 'D-MMM-YYYY')

jonathandienst — Fri, 23 Oct 2015 14:08:03 GMT

This is probably because the X- axis field is a string field and not a date field. With that date format, you cannot easily sort the strings.

Convert the field to a date field during the load:

LOAD...

myDatefield as strDateField,

Date(Date#(myDatefield, 'd-MMM-yyyy')) As DateField,

...

Then use DateField as the dimension and sort numerically. Change the field names to suit your document.