Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
hi, can anybody tell me in simple words what is IsNull() and why and where is it used?
 Gabriel
		
			Gabriel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Please read this blog post by HIC for better understanding of NULL
 Gysbert_Wassena
		
			Gysbert_Wassena
IsNull(expr) returns -1 (true) if expr returns NULL, otherwise 0 (false).
What part(s) of this sentence don't you understand?
 
					
				
		
 ToniKautto
		
			ToniKautto
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please remember to mark correct and helpful answers, to show your gratitude for the effort that has been put in to answering your questions. It will also indicate if you are happy with the replies or if you require more input.
 ashishpalkar
		
			ashishpalkar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Gysbert
How can we use following in Qlik?
,ISNULL(I.instrumentcusip,ISNULL(I.instrumentsedol,ISNULL(I.instrumentisin,I.instrumentticker))) AS [SECURITY ID]
thanks
 Gysbert_Wassena
		
			Gysbert_WassenaYou can use it as text to fill some space. Put '//' in front of it and it can be used as a comment.
Isnull takes only one argument. So it you try to use it with two arguments your script will throw an error.
If you have a question then creating a new discussion for it is a better idea than digging up a discussion that's been dead and buried for three years.
 
					
				
		
 jafari_ervin
		
			jafari_ervin
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		qlikview help is very useful.
