topic Re: Using NOT IN with IF in QlikView

Using NOT IN with IF

ndeeleysww — Mon, 01 Dec 2014 15:43:02 GMT

Hello,

I've written an IF expression in Qlik Sense which evalutes a team name and uses a hard coded default:

if(Team='Asset Visualisation', YearlyTarget, if(Team='Asset Information', YearlyTarget, if(Team='Asset Data Development', YearlyTarget, 30000)))

As you can see this is a bit inefficient, and I'd like to have a NOT IN list to evaluate rather than typing the condition again and again. I've tried various syntatx but can't get it to work. Can someone plese steer me in the right direction?

Thank you

Neil

Re: Using NOT IN with IF

fsimoes81 — Mon, 01 Dec 2014 15:54:13 GMT

Use the Match function:

If( NOT Match(Team, 'Asset Visualisation', 'Asset Information','OTHERS','do','don't do')

Re: Using NOT IN with IF

maxgro — Mon, 01 Dec 2014 19:51:41 GMT

=if(match(Team, 'Asset Visualisation', 'Asset......', 'Asset.....'), YearlyTarget, 3000)

Re: Using NOT IN with IF

ndeeleysww — Tue, 02 Dec 2014 08:45:39 GMT

Great! Thanks both for all your help!

Neil