Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for
Did you mean:
Not applicable

## How to change the order?

Anyone knows how to change the order of this sequence?

1 Solution

Accepted Solutions
Not applicable
Author

Try the following expression in the Chart,under Sort tab enable expression for corresponding dimension name

=Wildmatch(Dimensionname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

hope it will work...

7 Replies

In load script use dual function for month calculation

DUAL(Num(Month(Date)),Month(Date)) AS Month

Then sort by numeric in a chart

Regards,
Sergey
Specialist

You can also define Inline table in you data model.

and use Month_Sort for sorting    chart --> Sort tab ----> Expression --> max({1} Month_Sort)

LOAD * INLINE [

Month,Month_Sort

Jan,1

Feb,2

Mar,3

Apr,4

.......... so on

]

Not applicable
Author

Try the following expression in the Chart,under Sort tab enable expression for corresponding dimension name

=Wildmatch(Dimensionname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

hope it will work...

Specialist II

If u have a date field and u r showing data by month, then u can show it in order with the data field.

In sort use the expression  num(Date_field) and ascending.. this will work..

If u have data by onth, then u will have to create inline table to sort the month as shown by Chiru and u will have to link the month in the inline with ur data model.

Hope this helps.

Sundar

Not applicable
Author

If your calender is normal

then follow Chranjeevi's proposed solution

if your calender is financial calender

LOAD * INLINE [

Month,Month_Sort

Apr,1

May,2

Jun,3

Jul,4

.......... so on

]

and in Sort tab, use this expression : =Only({1} Month_Sort)

MVP

Load a inline table like

LOAD * INLINE [

Month,Month_Sequence

Jan,1

Feb,2

Mar,3

Apr,4

.......... so on

]

and use the Month_Sequence field in the properties -> expression -> type script like for sorting

Or

in properties -> expression -> type script like

=Match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Partner - Champion

How did you created the month field from date?

Using Simply Month function will give you month in Dual format, in that case you don't face this kind of issues.

"Month(DateFieldName) AS Month"

Community Browser