Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

];

View solution in original post

6 Replies
tresesco
MVP
MVP

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
Champion III
Champion III

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

so,

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Chanty4u
MVP
MVP
Author

thanks  Tresesco

its working as expcected

Chanty4u
MVP
MVP
Author

thanks vineet

satheshreddy
Creator III
Creator III

Hi Chanty,

you should define null value then it will work fine.

Regards

Sathish

Chanty4u
MVP
MVP
Author

yes satti its working fine now