Cross Table

[deepakqlikview_123]

Hi All,

PFA.

Can you please suggest how should i load attached data in cross table format.

Thanks

[its_anandrjs]

Try to load this way

CrossTable(Months, Data, 2)
LOAD * FROM

(ooxml, embedded labels, table is Sheet1);

Note:- Change your excel file location at your end.

Regards,

Anand

[deepakqlikview_123]

Hi anand,

I need columns like

perticular

sub perticular

month

data

Please suggest

[Chanty4u]

try this

Directory;

CrossTable(Months, Data, 2)

LOAD PARTICULARS,

     [Sub PARTICULARS],Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM

[..\Downloads\tp.xlsx]

(ooxml, embedded labels, table is Sheet1);

[its_anandrjs · Accepted solution]

This columns are there

perticular

sub perticular

month

data

see after loading this script.

Also you can do this way by removing Total rows because you are able to do sub total in qlikview it self so remove this rows.

Data:
CrossTable(Months, Data, 2)
LOAD * FROM

(ooxml, embedded labels, table is Sheet1);


NoConcatenate
Final:
LOAD * Resident Data
Where Left([Sub PARTICULARS],5) <> 'TOTAL';
DROP Table Data;

Regards

Anand

[deepakqlikview_123]

PFA

I am getting data shown in attachment please suggest is it fine or not

i used

CrossTable(Month, Data,4)

[its_anandrjs]

It seems correct for me if you not need the TOTAL rows you can remove them which represent Sub Totals

NoConcatenate
Final:
LOAD * Resident Data
Where Left([Sub PARTICULARS],5) <> 'TOTAL';
DROP Table Data;

Regards

Anand