Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi!!Could you try the following settings!
[Propaty] - [Sort]tab - cheack[Expression]
Set Expression「Date#([Incident Date],'MMMYYYY')」
click[OK]!!
HI
Go to Sort tab and then check the box Y-value--> Descending
thanks
Sasi
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.
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
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