Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hello i've a problem with the expression below, i've refered to the help guide within Qlikview and I believe I am following the correct syntax.
count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15'))
 
					
				
		
 deepakk
		
			deepakk
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi,
you need tao dd the field on which you need to count
count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15' , FIELDNAME ) )
Deepak
 
					
				
		
 deepakk
		
			deepakk
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi,
you need tao dd the field on which you need to count
count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15' , FIELDNAME ) )
Deepak
 
					
				
		
 jagannalla
		
			jagannalla
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I think you are missing column to count
count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15'))
=count(if(mid(Move_Out_Date,4,2)='07' and left(Post_Code,4)='SO15' ,ColumnName))
 
					
				
		
Thanks guys, I didnt have a field I wanted to use as count so I added the field '1 as count' in the same table as move out date so the final expression looked like this :- count(if(mid(Move_Out_Date,4,2)='08'and left(Post_Code,4)='SO15','Count'))
