Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Chanty4u
Esteemed Contributor III

IsNull

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?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: IsNull

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

];

6 Replies
MVP
MVP

Re: IsNull

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

];

vinieme12
Esteemed Contributor II

Re: IsNull

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

so,

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

Chanty4u
Esteemed Contributor III

Re: IsNull

thanks  Tresesco

its working as expcected

Chanty4u
Esteemed Contributor III

Re: IsNull

thanks vineet

satheshreddy
Contributor III

Re: IsNull

Hi Chanty,

you should define null value then it will work fine.

Regards

Sathish

Chanty4u
Esteemed Contributor III

Re: IsNull

yes satti its working fine now