topic Re: if statement in QlikView

if statement

Wed, 09 May 2012 10:09:08 GMT

Hi all,

i am trying to build a field based on other fields' values during the LOAD of a table:

// number sec IV answered

if ([4_1a_Answered] = 1, 1 +

if ([4_1b_Answered] = 1, 1 +

if ([4_1c_Answered] = 1, 1 +

if ([4_1d_Answered] = 1, 1, 0

)))) as [Number Sec IV answered],

The problem is that it does not work, if one ore more *_*_Answered fields are not 1. (If they are <> 1, i would just like to not count them (they can either be 1 or 0).

Thanks for some advise.

if statement

Wed, 09 May 2012 12:41:18 GMT

Anyone ? please..

Re: if statement

Wed, 09 May 2012 12:47:36 GMT

Have you tried seperating them into several if statments?

if ([4_1a_Answered] = 1, 1 )

if ([4_1b_Answered] = 1, 1 )

if ([4_1c_Answered] = 1, 1)

if ([4_1d_Answered] = 1, 1)

as [Number Sec IV answered],

However this may not work either as I am not sure how it will handle the nulls with adding. Can also try this:

if ([4_1a_Answered] = 1, 1,0 )

if ([4_1b_Answered] = 1, 1 ,0)

if ([4_1c_Answered] = 1, 1,0)

if ([4_1d_Answered] = 1, 1,0)

as [Number Sec IV answered],

if statement

Wed, 09 May 2012 13:23:19 GMT

Thanks.

I tried a

RangeSum([4_1a_Answered], [4_1b_Answered], [4_1c_Answered], [4_1d_Answered]) as [Number Sec IV answered]

that seems to work fine.

Re: if statement

jonathandienst — Wed, 09 May 2012 13:26:51 GMT

The problem is that 1 + Null() = Null(). You can use the Alt() statement to ensure that your addition works.

1 + Alt(Null(), 0) = 1

So use multiple If statements as marcsliving suggested, but wrap each with Alt(...., 0) so that if it is missing or null, then it will return 0.

Regards

Jonathan

Re: if statement

jonathandienst — Wed, 09 May 2012 13:28:09 GMT

Yes Rangesum handles nulls as 0 so it will work.

Regards

Jonathan