Incident Date Not in Order

[#1]

Hi

   In the attched .qvw, "Incidents By Time" chart & "Harmful Injuries" chart the Incident Date is not in the Time Order. (Jun2014, Jul2014 etc.)

Appreciate if you could let me know how to get that order.

Thanks

[kogasawara]

Hi！！Could you try the following settings!

[Propaty] - [Sort]tab - cheack[Expression]

Set Expression「Date#([Incident Date],'MMMYYYY')」

click[OK]!!

[sasikanth]

HI

Go to Sort tab and then check the box Y-value--> Descending

thanks

Sasi

[jagan · Accepted solution]

Hi,

Try like this, if you do this in script it would be better

LOAD Service,

     [Type Of Employment],

     Age,

     Gender,

     SAC,

     [Incident Type],

     [First Name],

     Surname,

     [Type of Worker],

     [Type of Incident],

     Harm,

     [Injured Workers Manager],

     Date(Monthend(Date#([Incident Date], 'MMMYYYY')), 'MMMYYYY') AS [Incident Date],

     Date(Date#([Incident Date], 'MMMYYYY')) AS Date,

     [Incident Category]

FROM

(biff, embedded labels, table is Sheet1$);

Converted your string month the numeric month, now use this [Incident Date] as dimension and in sort tab select numeric.

If you do not want to change the script then try like this

Chart Properties -> Sort-> Select Expression and give below expression

=Date#([Incident Date], 'MMMYYYY')

Hope this helps you.

Regards,

Jagan.

[SunilChauhan]

add below in script

Load * inline [

Incident Date,order

   Aug2014,3

Jul2014,2

Jun2014,1

Oct2014,5

Sep2014,4

];

and chart properties -> sort-> expression->order

hope this helps

[Anonymous]

Hey,

Place the following in sort expression under sort tab of properties:

=num(Right([Incident Date],4)&if (left([Incident Date],3)='Jan','01',if (left([Incident Date],3)='Feb','02',if (left([Incident Date],3)='Mar','03',

if (left([Incident Date],3)='Apr','04',if (left([Incident Date],3)='May','05',if (left([Incident Date],3)='Jun','06',if (left([Incident Date],3)='Jul','07',

if (left([Incident Date],3)='Aug','08',if (left([Incident Date],3)='Sep','09',if (left([Incident Date],3)='Oct','10',if (left([Incident Date],3)='Nov','11',

if (left([Incident Date],3)='Dec','12')))))))))))))

BR,

Chinna