Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Recoding in script

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?

4 Replies
datanibbler
Champion
Champion

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

Not applicable
Author

Many thanks!

maxgro
MVP
MVP

or

load

field,

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

inline [

field

1

2

3

4

5

6

];

Not applicable
Author

Massimo, thank you!