4 Replies Latest reply: Jul 13, 2015 2:55 AM by Marina Mezerova RSS

    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