cross table load problem

Anonymous — Tue, 14 Feb 2012 05:34:17 GMT

hi gurus,

problem in loading excel file(cross table)

plz find the attachment

Thanks in Advance

jagan — Tue, 14 Feb 2012 08:26:13 GMT

HI,

Check the following example

Excel File Data:

[Data]:

CrossTable(Months, Amount, 1)

LOAD Department,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM

[Sample Line Chart.xlsx]

(ooxml, embedded labels, table is [Sheet3]);

Hope this helps you.

Regards,

Jagan.

topic cross table load problem in QlikView