topic Re: Cross table ! in QlikView

Cross table !

Mon, 12 May 2014 13:16:37 GMT

CrossTable([Respondent ID],Response,5)

LOAD RespondentID as [Respondent ID] ,

Date,

Category,

WeekType,

QID as QuestionID,

Response

Resident Cust_Nov_Saving_Two_Wheeler;

am using above script for cross table.

i want convert the data from Response so the above cross table cant work getting error so can u suggests me

Thanks

Re: Cross table !

alexandros17 — Mon, 12 May 2014 13:24:30 GMT

is it CrossTable([Respondent ID],Response,4) ???

Re: Cross table !

Mon, 12 May 2014 13:27:01 GMT

i tried that one also but getting same error :

Field not found - <RespondentID>

CrossTable(RespondentID,Response,4)

LOAD RespondentID as [Respondent ID],

Date,

Category,

WeekType,

QID as QuestionID,

Response

Resident Cust_Nov_Saving_Two_Wheeler

Re: Cross table !

alexandros17 — Mon, 12 May 2014 13:45:25 GMT

It is right ... [Respondent ID] is the field to use!

Re: Cross table !

Mon, 12 May 2014 13:54:29 GMT

yes Respondent ID is the field am using same format in cross table syntax but i can get ans