Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to treat null values as 'o' in order to make calculations
script or presentation ?
Script
Should i be
Set NullDisplay=;
NullAsValue *;
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
Jason post a good idea
or you can just use if(isnull(sssssssssssss)) function
Be careful with IsNull() over a large recordset though - see Nicolas' comments here:
thanks a lot:)