topic Re: IsNull in QlikView

IsNull

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

Hi all,

below link i checked

Mapt - Developer skills delivered

I am bit confused on below ISnull scenario Can anyone give some clarification on this?

Data:

Load

Country,

If(IsNull(Sales), 0, Sales) As Sales

Inline [

Country, Sales

USA, 1020

UK, 965

Germany,

France, 890

];

if i use --- If(IsNull(Sales), 0, Sales) As Sales this condition still giving same results if not also same.

how it is used?

Re: IsNull

tresB — Mon, 23 Oct 2017 08:57:31 GMT

Inline load is like text file, it can't contain NULL values. If you want to get the impact of NULL in inline load try like:

Set NullInterpret = '';

Data:

Load

Country,

If(IsNull(Sales), 0, Sales) As Sales

Inline [

Country, Sales

USA, 1020

UK, 965

Germany,

France, 890

];

Re: IsNull

vinieme12 — Mon, 23 Oct 2017 08:57:47 GMT

You can use Alt() that returns the first non-null values

so,

If(IsNull(Sales), 0, Sales) == Alt(Sales,0)

Re: IsNull

Chanty4u — Mon, 23 Oct 2017 09:09:43 GMT

thanks Tresesco

its working as expcected

Re: IsNull

Chanty4u — Mon, 23 Oct 2017 09:10:01 GMT

thanks vineet

Re: IsNull

satheshreddy — Mon, 23 Oct 2017 09:19:16 GMT

Hi Chanty,

you should define null value then it will work fine.

Regards

Sathish

Re: IsNull

Chanty4u — Mon, 23 Oct 2017 09:24:13 GMT

yes satti its working fine now