Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change the order?

Anyone knows how to change the order of this sequence?

Capture1.PNG.png

Capture.PNG.png

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...

View solution in original post

7 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

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
chiru_thota
Specialist
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...

sundarakumar
Specialist II
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

Follow like this

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)

its_anandrjs

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')

CELAMBARASAN
Partner - Champion
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"