Help Needed in Qlik Sense month order

[daisy1438]

Hi ,

I am creating stacked bar chart  using my orederdate field for last 6 months sales.

dimension= Order date

for month year format i am writing  below expression.

=Month([Order Date]) &'-'& Date(Date#([Order Date],'MM/DD/YYYY'),'YY')

it is coming last 6 months by writing my expression.

but months not showing order wise.

dec, mar,apr....like

i need order Jan feb mar...like that.please help on this.

[tresB]

Sort by expression: =[Order Date]

[muthukumar77]

Hi

Use dimension and sort by expresion also,

=Month([Order Date]) &'-'& Year(Date#([Order Date],'MM/DD/YYYY'))