Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Help Needed in Qlik Sense month order

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.

 

2 Replies
Highlighted
MVP
MVP

Re: Help Needed in Qlik Sense month order

Sort by expression: =[Order Date]

Highlighted
Partner
Partner

Re: Help Needed in Qlik Sense month order

Hi

Use dimension and sort by expresion also,

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

 

 

Muthukumar Pandiyan