topic Re: Need help! in QlikView

Need help!

Tue, 22 Dec 2015 18:38:07 GMT

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.

Re: Need help!

sunny_talwar — Tue, 22 Dec 2015 19:11:35 GMT

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;

Re: Need help!

maxgro — Tue, 22 Dec 2015 20:04:41 GMT

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;