Date issue in Charts

[#1]

Hello,

I have some data that starts in August 2013 and continues through January 2014.  I would like the X axis to go in the following order:  August, September, October, November, December, January.

However January is the first month on the X-Axis.  How do I fix this?  The dates were uploaded with the years.

[#2]

Hi Michael

you can use the sort order by "original load"

it will sort it according your order load, so it may be necessary to

LOAD

...

FROM

ORDER BY Date;

best regards

Chris

[#3]

....and  if you have a date format as MMM-YY  use "Numeric"  to sort data

check your date format as numeric

Chris

[#4 · Accepted solution]

Is it Monthyear?    In Sort "Expression"   =Num(Monthyear) Ascending...

Selva

[#5]

Hi,

You can use  wildmatch( M, 'Aug*','Sep?','Oct')

in sort tab of chart.

It'll returns you the numeric value 1, 2,3 and so on...

By this way you can sort in any order...

Regards

Garry

[rajeshvaswani77]

Hi Michael,

In the sort tab select the date field, then check Numeric Value and choose Ascending.

thanks,

Rajesh Vaswani

[senpradip007]

Hi Michael,

Create Month Order in your Calender,

e.g.

Apr - 1

May - 2

Jun - 3

Jul - 4

Aug - 5

.

Dec - 9

Jan - 10

Feb - 11

Mar - 12

You will reach your goal.

Regards

PS

[#8]

Hi Michal,

Create a one small inline table with the order of your month and give the order like below

LOAD * INLINE [

    Month, MonthRank

    August, 1

    September, 2

    October, 3

    November, 4

    December, 5

    January, 6

    Feb, 7

    Mar, 8

    Apr, 9

    May, 10

    Jun, 11

    July, 12

];

and then link this inline to your Table month field and in front end go to Sort Tab choose Expression Option and mention

=MonthRank.

Regards,

Santhosh G

[Luis_Cortizo]

In case you want to custom Order a field in QlikView, the easiest way for me is creating an Inline table on the beggining of the script.

For instance, you can load this table at the beggining of the script (supposing that the field that you want to custom sort is called Month):

_tmpSortMonth:

LOAD * INLINE [

    Month

    August

    September

    October

    November

    December

    January

    February

    March

    April

    May

    June

    July

];

All you need to do after that is drop this table at the end of the script:

Drop Table _tmpSortMonth;

And on the chart you should select Load Order as Christian Juillard suggested.

As the first appearance of the field Month is loaded in that specific order, the rest of the data will be shown on the chart on that specific order.