How do I get the dates in my bar chart in order of date?

[#1]

Hi

I want to import a sales funnel with lots of projects that have end dates in the DD/MM/YYYY format. 

I have already added another column of dates using the =text(date,"MMM-YY").

However I cannot get Qlik to either:

• Cluster the individual DD/MM/YYYY values into months OR
• Put the dates using the MMM-YY format, into date order

I don't know if the problem is solved in:

1. Excel formatting before data load
2. During the script execution for the load
3. In the dashboard app display settings to the right hand side of the dashboard in edit view

Any help would be appreciated.

[aarkay29]

Your sorting seems to be based on the expression desc instead of sort by MonthYear dimension

[#3]

‌hi,

i am not using any expressions.  How do I get the sorting to be based on the month year dimension?

regards

oliver

[MK9885]

To sort the dates in Sep, Oct, Nov Dec...

you need to do it in Sorting for the chart, properties.

Sort by expression.

Maybe use below expression and change Yourexpression with your actual expression.

aggr(YourExpressionHere), MonthYear)

Either use Ascending or Descending upon your requirement.

[MK9885]

If the you found the result, please close this by marking it Correct Answer.

Thanks.

[#6]

Hi,

I have just solved it with your help!

Thank you very much!

[#7]

Hi

How do I mark it has correct answer?

[MK9885]

Check on the left bottom of the post and click 'Correct Answer'

Thanks.