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?