topic Re: If statement with NOT NULL in QlikView

If statement with NOT NULL

Mattia — Sat, 16 Nov 2024 19:37:59 GMT

Hi guys,

i need to modifiy the following expression, because it don't works.

If(Len(Trim([@183:190]<>'')), Mid([@183:190],3,2), Mid([@18:25],3,2))

The output i want is that If(Len(Trim([@183:190] IS NOT NULL, i must see Mid([@183:190],3,2), otherwise Mid([@18:25],3,2).

Please, someone can help me?

Thanks,

Mattia

Yousef_Amarneh — Wed, 20 Nov 2019 12:04:49 GMT

I don't know why you are using len(), however, if you want to check if the field is null or not better to use isnull() fundtion

If(Trim([@183:190])='' or IsNull([@183:190]), Mid([@18:25],3,2),Mid([@183:190],3,2))

Mattia — Wed, 20 Nov 2019 13:19:05 GMT

Thx Yousef!!!

Now it works perfectly.

Mattia

sunny_talwar — Wed, 20 Nov 2019 13:26:31 GMT

You can also try

If(Len(Trim([@183:190])) > 0, Mid([@183:190], 3, 2), Mid([@18:25], 3, 2))