Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community, I have a question regarding the CrossTable script in Qlik Sense.
I think I'm following the script properly but maybe not as I keep getting the attached error.
I've attached the spreadsheet in question and if someone could help me to solve the issues I'd be extremely grateful.
Thanks!
CrossTable(Servise, Data, 2)
LOAD Date,
[Guest Name],
value,
staff,
service,
clean,
comfort,
location,
Overall
FROM
(ooxml, embedded labels, table is Sheet1);
Results:
Hi,
try Crosstable("Guest Name" ........) or [Guest Name]
Guest Name is already a field, try some other field name as you cannot repeat field names
CrossTable([FieldName 1], [Value Field], 2)
LOAD Date,
[Guest Name],
....
FROM ....
CrossTable(Servise, Data, 2)
LOAD Date,
[Guest Name],
value,
staff,
service,
clean,
comfort,
location,
Overall
FROM
(ooxml, embedded labels, table is Sheet1);
Results: