topic Re: Incident Date Not in Order in QlikView

Incident Date Not in Order

Tue, 25 Nov 2014 05:13:08 GMT

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

Re: Incident Date Not in Order

kogasawara — Tue, 25 Nov 2014 05:20:43 GMT

Hi！！Could you try the following settings!

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

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

click[OK]!!

Re: Incident Date Not in Order

sasikanth — Tue, 25 Nov 2014 05:24:53 GMT

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

thanks

Sasi

Re: Incident Date Not in Order

jagan — Tue, 25 Nov 2014 05:36:48 GMT

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.

Re: Incident Date Not in Order

SunilChauhan — Tue, 25 Nov 2014 05:50:25 GMT

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

Re: Incident Date Not in Order

Anonymous — Tue, 25 Nov 2014 06:15:46 GMT

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