Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Using NOT IN with IF

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

1 Solution

Accepted Solutions
MVP
MVP

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

View solution in original post

3 Replies
Partner
Partner

Use the Match function:

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

MVP
MVP

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

View solution in original post

Creator
Creator

Great! Thanks both for all your help!

Neil