Matching Month('date') with Inline Month

Wed, 01 Aug 2012 03:55:16 GMT

Can anyone teach me how to match the month that is generated by the "month" function with the one that is from the Inline table?

When I just load it as per normal with joining the tables, duplication appears but when I used "Left Join", my items in the Inline table disappears.

Is that not the right way to do so?

My code is as follows:

Left Join(Jobworkhrdata)

LOAD month([Posting Date]) as workmonth,

year([Posting Date]) as workyear,

[No_],

Sum([Hour X 1_0]) as 1,

Sum([Hour X 1_5]) as 2,

Sum([Hour X 2_0]) as 3

GROUP BY [No_], month([Posting Date]), year([Posting Date]);

SELECT [Job No_],

[Posting Date]

,[No_]

,[Hour X 1_0]

,[Hour X 1_5]

,[Hour X 2_0]

FROM database

where [Type] = '0' and [Job No_] like 'J______'

;

//Left Join (Jobworkhrdata)

LOAD * INLINE [

workmonth, workMonth, Manhour

Jan, 1, 167

Feb, 2, 185

Mar, 3, 193

Apr, 4, 177

May, 5, 194

Jun, 6, 184

Jul, 7, 194

Aug, 8, 184

Sep, 9, 176

Oct, 10, 195

Nov, 11, 174

Dec, 12, 168

];

topic Matching Month('date') with Inline Month in QlikView