Sorting of a date in descending order

[#1]

Good day,

Please could you assist me.

I am trying to sort the date in descending order but it’s not allowing me to sort it this way. I would like the data to show Oct 13, Sep 13 then Aug 13.

I have 3 dimensions and one expression variable. I’m not sure what the issue is.

I am using Qlikview 10.

Thanks.

Kind Regards,

Celeste

[tresesco]

Possibly you have created this [Month Year] field using some string functions rather than standard date functions, and that is causing the issue(soritng as text). Use proper date function to get the date format you want; sort would work fine then. If any doubt, please share a sample qv file with sample data.

[#3]

Thanks Tresesco. I appreciate the comment.

Apparently, because I have used a calculated date I can't sort the calculated date. I have to first create the date in the script and then use it in my graph. It then works fine!

Kind Regards,

Celeste