topic Re: Recoding in script in QlikView

Recoding in script

Mon, 08 Jun 2015 12:12:14 GMT

Hi everyone!

I'm a beginner in working with QlickView.

Which function allows to recode values? For example, I have Field with six values (1,2,3,4,5,6) and I want to recode them this way (1 2 3 = copy) (4 5 = 4) (6=5).

is it possible to do that within LOAD function?

Re: Recoding in script

datanibbler — Mon, 08 Jun 2015 12:20:18 GMT

Hi Marina,

sure. There are several ways. You can do it in the LOAD with an IF-function or you can use a mapping table. The latter is more practical if the method of recoding can change over time (if going forward, you might want to map 4 against 'copy', too)

HTH

Re: Recoding in script

Wed, 10 Jun 2015 13:32:36 GMT

Many thanks!

Re: Recoding in script

maxgro — Fri, 26 Jun 2015 18:09:46 GMT

load

field,

pick(match(field, 1,2,3,4,5,6), 1,2,3,4,4,5)

inline [

field

];

Re: Recoding in script

Mon, 13 Jul 2015 06:53:31 GMT

Massimo, thank you!