Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Recoding of categorical data

Hi community!

I'm quite new in qlickview. Could anyone, please, help me with recoding categorical data of one field.

I've tried doing it using IF-function.

For example I have a field Occupation with codes like Financial Accounting, Information Technology, Marketing, Advertising, Education, Public Health Service. I need to recode it into new field Ocup with codes 'Social' (if Occupation = Education OR Public Health Service), 'Marketing' (if Occupation = Marketing OR  Advertising), 'Other' (if Occupation = Financial Accounting OR Information Technology).

How IF-function should be script for taking into accounts these conditions?

Many thanks in advance!


4 Replies

Re: Recoding of categorical data


have a look into Henric's latest blog post:

Data Cleansing

Contributor III

Re: Recoding of categorical data

hope this help

Not applicable

Re: Recoding of categorical data

Swuehl, thanks!

Not applicable

Re: Recoding of categorical data


thank you so much! It works great!

Community Browser