topic Re: multiple conditions in new calculated field in Visualization and Usability

multiple conditions in new calculated field

dlechuga — Sat, 16 Nov 2024 20:00:58 GMT

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!!!

Re: multiple conditions in new calculated field

DavidM — Wed, 25 Sep 2019 16:49:44 GMT

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])

Re: multiple conditions in new calculated field

dlechuga — Wed, 25 Sep 2019 20:48:09 GMT

Thanks a lot! it did work. =D