topic Re: If statement with multiple conditions? in QlikView

If statement with multiple conditions?

Tue, 19 Mar 2013 20:11:25 GMT

I'm trying to develop an If statement that matches several conditions. The reason I am trying to do this is to remove some data that isn't necessary.

We often have people testing inside our database. They'll use a User ID like "ed_t" or "D_ET". So I when I import my data, I don't want to include those in the dataset at all.

My If statement doesn't seem to work, though. It only matches the first condition. Any thoughts?

If(left(lower([User ID]), 3) <> 'ed_t' or 'D_ET', 1) as [Exclude User ID]

Re: If statement with multiple conditions?

srinivasa1 — Tue, 19 Mar 2013 20:26:34 GMT

Write like below

If(left(lower([User ID]), 3) <> 'ed_t' or left(lower([User ID]), 3) <> 'D_ET' , 1) as [Exclude User ID]

Re: If statement with multiple conditions?

Tue, 19 Mar 2013 21:40:58 GMT

one comment about lower and 'D_ET': that won't work together:

if lower is necessary, use 'd_et'

Re: If statement with multiple conditions?

Tue, 19 Mar 2013 23:25:14 GMT

If you're comparing the same field in each condition, you can use match, mixmatch, or wildmatch for case sensitive, case insensitive, and wild card matches.

Re: If statement with multiple conditions?

jagan — Wed, 20 Mar 2013 06:19:20 GMT

Hi,

Try like this

if(mixmatch([User ID], 'ed_t', 'D_ET'), 1 ) AS [Exclude User ID]

Hope this helps you.

Regards,

Jagan.