CrossTable Error

[Anonymous]

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!

[stabben23]

Hi,

try Crosstable("Guest Name"   ........) or [Guest Name]

[sunny_talwar]

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 ....

[MindaugasBacius · Accepted solution]

CrossTable(Servise, Data, 2)
LOAD Date, 
     [Guest Name], 
     value, 
     staff, 
     service, 
     clean, 
     comfort, 
     location, 
     Overall
FROM

(ooxml, embedded labels, table is Sheet1);

Results: