topic Help with embedded if statement in QlikView

Help with embedded if statement

Wed, 01 Jul 2015 19:42:24 GMT

Hey,

Can anyone help me with this? for some reason it won't pull in the 'Billable', and I am thinking it is something to do with the dash. The Bus Dev and the Non- Bus Dev are working fine.

if(left(AccountNumber,7)= '-', 'Billable',if(left(AccountNumber,2) = '56', 'Business Development'), 'Non-Business Development')) as [Expense Type]

Re: Help with embedded if statement

m_woolf — Wed, 01 Jul 2015 19:44:55 GMT

left(AccountNumber,7) will return the first 7 chartacters at the left of the AccountNumber field.

The first 7 characters can't be equal to "-"

Re: Help with embedded if statement

Anonymous — Wed, 01 Jul 2015 19:49:49 GMT

is the dash in the field or does it represent a null field

if it represents a null try

if(len(left(AccountNumber,7))>0, 'Billable',if(left(AccountNumber,2) = '56', 'Business Development', 'Non-Business Development')) as [Expense Type]

if the dash is the correct character then you have an extra close bracket

if(left(AccountNumber,7)= '-', 'Billable',if(left(AccountNumber,2) = '56', 'Business Development', 'Non-Business Development')) as [Expense Type]

hope this helps

Re: Help with embedded if statement

Anonymous — Wed, 01 Jul 2015 19:54:26 GMT

Hi,

you should use mid functions and not left.

In your example if(AccountNumber,7,1)='-' ...

Regards.

Re: Help with embedded if statement

Wed, 01 Jul 2015 20:01:22 GMT

Makes Sense, but I am trying to pull the first 6 characters as 'Billable' and the account number is 012345-0444.

Re: Help with embedded if statement

MarcoWedel — Wed, 01 Jul 2015 21:21:51 GMT

If(Mid(AccountNumber,7,1)='-' ...