topic choose the first non-null value in QlikView

choose the first non-null value

ali_hijazi — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I got three variables

v1, v2, and v3

i want to use these inside an expression but as follows:

if($(v1) is not null null then $(v1)

if($(v1) is null then if $(v2) is null then $(v3) else $(v2)

is there a way or a function that chooses the first non null value ?

the priority is for V1, then V2 and finally V3

Anil_Babu_Samineni — Tue, 23 May 2017 12:51:22 GMT

May be this?

1) If($(v1) <> '0' or $(v1) <> ' ' or $(v1) <> '-', $(v1))

2) If(IsNull($(v1)), If(IsNull($(v2)), $(v3), $(v2)))

antoniotiman — Tue, 23 May 2017 14:22:08 GMT

Maybe

Alt(V1,V2,V3)

Regards,

Antonio

Anonymous — Wed, 24 May 2017 11:29:05 GMT

Hi,

Maybe this:

If(not IsNull($(v1)), $(v1),

if(IsNull($(v1)), if(IsNull($(v2)),$(v3),$(v2)

)