topic Re: Date issue in Charts in QlikView

Date issue in Charts

Wed, 08 Jan 2014 10:41:10 GMT

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.

Re: Date issue in Charts

Wed, 08 Jan 2014 10:44:26 GMT

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

Re: Date issue in Charts

Wed, 08 Jan 2014 10:45:50 GMT

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

check your date format as numeric

Chris

Re: Date issue in Charts

Wed, 08 Jan 2014 10:50:04 GMT

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

Selva

Re: Date issue in Charts

Wed, 08 Jan 2014 10:55:13 GMT

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

Re: Date issue in Charts

rajeshvaswani77 — Wed, 08 Jan 2014 10:57:17 GMT

Hi Michael,

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

thanks,

Rajesh Vaswani

Re: Date issue in Charts

senpradip007 — Wed, 08 Jan 2014 10:58:21 GMT

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

Re: Date issue in Charts

Wed, 08 Jan 2014 11:00:41 GMT

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

Re: Date issue in Charts

Luis_Cortizo — Wed, 08 Jan 2014 11:05:57 GMT

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.