topic using a Cross tab in excel in QlikView

using a Cross tab in excel

Tue, 18 Aug 2009 18:27:18 GMT

Hello All,

I have some data in Excel file. I need to cross tab it .

The column format goes like this

StdntRNo StdntName ClassName JAN FEB MAR Q1 APR MAY JUN Q2 JUL AUG SEPT Q3 OCT NOV DEC Q4

Whole data is loaded in one sheet .

I need to cross tab wrt to JAN FEB MAR APR MAY JUN JUL AUG ..

Moreover I also want to load the Q1 Q2 Q3 Q4 simultaneously.

How can I do so . I want to avoid any manual work.

Suggestions are invited.

using a Cross tab in excel

stephencredmond — Tue, 18 Aug 2009 18:37:18 GMT

You could do it like this:


 Classes:
CrossTable(Month, MonthValue, 3)
LOAD StdntRNo,
 StdntName,
 ClassName,
 JAN,
 FEB,
 MAR,
 APR,
 MAY,
 JUN,
 JUL,
 AUG,
 SEPT,
 OCT,
 NOV,
 DEC
FROM
Classes.xls
(biff, embedded labels, table is Sheet1$);

CrossTable(Quarter, QuarterValue, 3)
LOAD StdntRNo,
 StdntName,
 ClassName,
 Q1,
 Q2,
 Q3,
 Q4
FROM
Classes.xls
(biff, embedded labels, table is Sheet1$);

Would it not be easier to derive Quarters within QlikView?

Stephen