Re:Cross Table

[t_vijay_qlik]

Hi all,

Cross table xls file error

[swuehl · Accepted solution]

Worked for me with your xls file. Try to create a new QVW.

Test:

Crosstable(Month,Sales)

LOAD Department,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM

[Crosstable example.xls]

(biff, embedded labels, table is Sheet1$);