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!

Marina

4 Replies
MVP
MVP

Re: Recoding of categorical data

Marina,

have a look into Henric's latest blog post:

Data Cleansing

florentina_doga
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

Florentina,

thank you so much! It works great!

Community Browser