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: 
gaurav2017
Creator II
Creator II

Null as "0"

How to treat null values as 'o' in order to make calculations

7 Replies
Not applicable

script or presentation ?

gaurav2017
Creator II
Creator II
Author

Script

gaurav2017
Creator II
Creator II
Author

Should i be

Set NullDisplay=;

NullAsValue *;

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Have a look at my explanation of NULL values and how to deal with them here -

http://community.qlik.com/message/238563#238563

Hope this helps,

Jason

Not applicable

Jason post a good idea

or you can just use if(isnull(sssssssssssss)) function

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Be careful with IsNull() over a large recordset though - see Nicolas' comments here:

http://community.qlik.com/message/237970#237970

Not applicable

thanks a lot:)