Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 syukyo_zhu
		
			syukyo_zhu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
In my expression, sometimes i got "error: error in expression".
So i want to know if there is a way i can just show 0 in the case "error" and show my value in others cases.
thanks
 
					
				
		
 arulsettu
		
			arulsettu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		what is your expression
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Not clear
can u post ur exprsn and error?
or sample qvw??
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		AFAIK, I don't think QlikView allows for this kind of error handling on the front end
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Arul this all seems back end handling, I don't think any of this can be implemented on the front end? Can it?
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		there is standard
in qlikview
0 No error
1 General error
2 Syntax error
3 General ODBC error
4 General OLE DB error
5 General custom database
error
6 General XML error
7 General HTML error
8 File not found
9 Database not found
10 Table not found
11 Field not found
12 File has wrong format
13 BIFF error
14 BIFF error encrypted
15 BIFF error unsupported
version
16 Semantic error
 
					
				
		
 arulsettu
		
			arulsettu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		yes you are correct 
 
					
				
		
 syukyo_zhu
		
			syukyo_zhu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Error is in my text object not in the scrip
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		can u share ur expression?
 
					
				
		
 syukyo_zhu
		
			syukyo_zhu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		it's a shame.
