Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need help!

I have survey response for more than 100 questions like

No Knowledge/Experience

Beginner

Applying

Leading

Expert


I want to predefine them as number like 1 -5. So each time when load a file (Responses are in different  file) it should automatically consider the response as numbers. Is there a way in qlikview to do that . please help.

2 Replies

Re: Need help!

May be create a Mapping Table:

MappingTable:

Mapping

LOAD * Inline [

Response, NumResponse

No Knowledge/Experience, 1

Beginner, 2

Applying, 3

Leading, 4

Expert, 5

];


FactTable:

LOAD Responses,

          ApplyMap('MappingTable', Responses) as Numbered_Response

From Source;

MVP
MVP

Re: Need help!

another could be

load Response, AutoNumber(Response) as ResponseId inline [

Response

No Knowledge/Experience

Beginner

Applying

Leading

Expert

];

load

  AutoNumber(Response) as ResponseId,

  ......     // other fields

From YourFile;

Community Browser