Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to load this format excel in qlik sense. i want to display month wise and perform sum calculation
I think you can use crosstable to unpivot the table in the script
This data is a bit messy, but you can do it.
Data:
CrossTable(Category, Value, 4)
LOAD
F1 AS Id,
F2 as Name,
Gender,
'April' as Month,
A,
"B",
C,
D,
"E",
F,
Travel
FROM [lib://Community/Crosstable.xlsx]
(ooxml, embedded labels, header is 1 lines, table is cross);
Crosstable(Category, Value, 4)
LOAD
F1 AS Id,
F2 as Name,
Gender,
'May' as Month,
A1,
B1,
C1,
D1,
E1,
F3
FROM [lib://Community/Crosstable.xlsx]
(ooxml, embedded labels, header is 1 lines, table is cross);