Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Cross Table

Hi All,

PFA.

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

Thanks

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

6 Replies
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
Specialist
Specialist
Author

Hi anand,

I need columns like

perticular

sub perticular

month

data

Please suggest

Chanty4u
MVP
MVP

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

cross.PNG

its_anandrjs

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
Specialist
Specialist
Author

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