topic Re: Adding IsNull to If Statement to Expression in QlikView

Adding IsNull to If Statement to Expression

Tue, 20 Jan 2015 21:49:36 GMT

Hi,

I'm struggling to find the right syntax in adding a if(IsNull to an existing expression: Here is the existing expression:

if([Salespercent]<.90, 0,

if([Salespercent]>=.90 and [Salespercent] <=.957, 2,

if([Salespercent]>=.958, 3

)))

I need to add an IsNull to the expression so if the [SalesPercentField] is Null it returns 0

Can someone please help? Thank you.

Brian

Tue, 20 Jan 2015 22:02:23 GMT

Hi Brian,

you can just put the 0 into you final else condition, which will catch any null as they will fall out of all of your prior true statements.

if([Salespercent]<.90, 0,

if([Salespercent]>=.90 and [Salespercent] <=.957, 2,

if([Salespercent]>=.958, 3,0

)))

hope that helps

Joe

Tue, 20 Jan 2015 22:12:03 GMT

Thanks!

Colin-Albert — Tue, 20 Jan 2015 22:13:26 GMT

You can test if the field length is zero

If( len( [SalesPercentField] ) > 0, 'Field is not null', 'Field is null')