multiple conditions in new calculated field

[dlechuga]

Hi! 

I'm very new at this I am starting to learn qlik and i am trying to do the following :

Create a calculated field with multiple conditions.

The follwing formula with one condition is working but once i try to include "and" or "or" it stops working

If([COMMERCIAL / RETAIL]='Partner - Audit Firm','Partner',[COMMERCIAL / RETAIL])

Any suggestions? what am trying yo do is if it found the following values 'Partner - Audit Firm' 'Partner - Consulting Firm' 'Partner - Private Equity Firm' then 'Partner' else value from [COMMERCIAL / RETAIL]

Thanks!!! 

[DavidM]

It's better to use if & (wild)match in this case:

If(Wildmatch([COMMERCIAL / RETAIL],'Partner - Audit Firm','Partner - Consulting Firm','Partner - Private Equity Firm' )>0,'Partner',[COMMERCIAL / RETAIL])

[dlechuga]

Thanks a lot! it did work. =D