Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA.
Can you please suggest how should i load attached data in cross table format.
Thanks
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
(
NoConcatenate
Final:
LOAD * Resident Data
Where Left([Sub PARTICULARS],5) <> 'TOTAL';
DROP Table Data;
Regards
Anand
Try to load this way
CrossTable(Months, Data, 2)
LOAD * FROM
(
Note:- Change your excel file location at your end.
Regards,
Anand
Hi anand,
I need columns like
perticular
sub perticular
month
data
Please suggest
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);
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
(
NoConcatenate
Final:
LOAD * Resident Data
Where Left([Sub PARTICULARS],5) <> 'TOTAL';
DROP Table Data;
Regards
Anand
PFA
I am getting data shown in attachment please suggest is it fine or not
i used
CrossTable(Month, Data,4)
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