topic Re: Recoding of categorical data in QlikView

Recoding of categorical data

Tue, 07 Jul 2015 09:28:40 GMT

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

Re: Recoding of categorical data

swuehl — Tue, 07 Jul 2015 09:32:06 GMT

Marina,

have a look into Henric's latest blog post:

Data Cleansing

Re: Recoding of categorical data

florentina_doga — Tue, 07 Jul 2015 10:24:52 GMT

hope this help

Re: Recoding of categorical data

Mon, 13 Jul 2015 06:54:35 GMT

Swuehl, thanks!

Re: Recoding of categorical data

Mon, 13 Jul 2015 06:55:09 GMT

Florentina,

thank you so much! It works great!