topic Re: CrossTable Error in QlikView

CrossTable Error

Anonymous — Tue, 13 Sep 2016 02:58:16 GMT

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!

Re: CrossTable Error

stabben23 — Tue, 13 Sep 2016 05:07:04 GMT

Hi,

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

Re: CrossTable Error

sunny_talwar — Tue, 13 Sep 2016 05:14:29 GMT

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

Re: CrossTable Error

MindaugasBacius — Tue, 13 Sep 2016 05:18:09 GMT

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

(ooxml, embedded labels, table is Sheet1);

Results: