topic Set Analyis to replace isnull in QlikView

Set Analyis to replace isnull

Tue, 21 Sep 2010 14:54:55 GMT

I have been on a crusade to eliminate if statements in expressions.

I have the below statement that I don't know if Set would help.

If anyone has thoughts I would appreciate it.

Sum ([ A ]) - sum(if(IsNull([ B] ),[ C ],[ B ]))

Basically this subtracts B from A unless B is null then is uses C

Tue, 21 Sep 2010 15:45:18 GMT

Hi pshicks,

I tried this:


(isnull(B)*-1)*C + (isnull(B)+1)*B

But if B is null you can't calculate with it: x+null = null

You only can calculate with independent Values:


(isnull(A)*-1)*C + (isnull(A)+1)*B

This means if A is Null sum(C) else sum(B)

Have Fun

Alex:)