topic Re: Adding up the dataset values. in QlikView

Adding up the dataset values.

Wed, 23 Dec 2015 19:28:54 GMT

I have survey responses like expert, beginner etc.

I want to convert all the text to numbers in qlikview

i loaded the file in qlikview but i need for eg expert as 5 beginner as 1

How do i do that.

Is there any function like setting up the value for these text

please help

Re: Adding up the dataset values.

Anonymous — Wed, 23 Dec 2015 19:45:20 GMT

Use a mapping.Data Cleansing

Re: Adding up the dataset values.

sunny_talwar — Wed, 23 Dec 2015 19:47:44 GMT

Create a Mapping Load

MappingTable:

Mapping

LOAD * Inline [

Text, Number

Expert, 5

Intermediate, 3

Beginner, 1

];

FactTable:

LOAD Level,

ApplyMap('MappingTable', Level) as Number

FROM Source;

Re: Adding up the dataset values.

swuehl — Wed, 23 Dec 2015 19:49:29 GMT

You could map your values like

MAP:
MAPPING LOAD

old, dual(old, number) AS new

INLINE [

old, number

expert, 5

beginner, 1

];

Then in your survey table, use something like

LOAD

survey,

ApplyMap('MAP', response) AS response

FROM SurveyTable;

edit:

I've used a dual value, so you have both text and number at hand, using num() or text().

Re: Adding up the dataset values.

maxgro — Wed, 23 Dec 2015 19:55:45 GMT

maybe an if or a pick/wildmatch or pick/match

load

pick(wildmatch(yourfield, 'expert', 'beginner', '*'), 5, 1, 0) as newfield,

yourfield

inline [

yourfield

expert

beginner

other

];