topic Re: How to change the order? in QlikView

How to change the order?

Wed, 09 Apr 2014 03:35:23 GMT

Anyone knows how to change the order of this sequence?

Re: How to change the order?

SergeyMak — Wed, 09 Apr 2014 03:47:03 GMT

In load script use dual function for month calculation

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

Then sort by numeric in a chart

Re: How to change the order?

chiru_thota — Wed, 09 Apr 2014 03:59:55 GMT

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

]

Re: How to change the order?

Wed, 09 Apr 2014 04:16:53 GMT

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

Re: How to change the order?

sundarakumar — Wed, 09 Apr 2014 04:25:23 GMT

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

Re: How to change the order?

Wed, 09 Apr 2014 04:56:18 GMT

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)

Re: How to change the order?

its_anandrjs — Wed, 09 Apr 2014 05:02:08 GMT

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

in properties -> expression -> type script like

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

Re: How to change the order?

CELAMBARASAN — Wed, 09 Apr 2014 05:35:45 GMT

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"