Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
t_vijay_qlik
Contributor III
Contributor III

Re:Cross Table

Hi all,

Cross table xls file error

Capture1.PNG

Capture2.PNG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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$);

2018-09-01 16_26_39-QlikView x64 - [E__Users_Stefan_Downloads_TEST_280818.qvw_].png

View solution in original post

1 Reply
swuehl
MVP
MVP

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$);

2018-09-01 16_26_39-QlikView x64 - [E__Users_Stefan_Downloads_TEST_280818.qvw_].png

View solution in original post