loading data in qliksense

[iswarya]

How to load this format excel in qlik sense. i want to display month wise and perform sum calculation

[Vicky_Z]

I think you can use crosstable to unpivot the table in the script

[Lisa_P]

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