Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
iswarya
Partner - Creator
Partner - Creator

loading data in qliksense

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

2 Replies
Vicky_Z
Support
Support

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

Lisa_P
Employee
Employee

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