Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 prabunakil
		
			prabunakil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all, please assist to share the expression.
My criteria is as per below:
1. [Bill Type] = {'ZLF2'}, [KSCHL]={'Z1PR'}
2. [Billing Item] = [Billing Item2]
3. Sum [KONV_KWERT]
 prma7799
		
			prma7799
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this
Sum( {<[Billing Item] = {'[Billing Item2]'} , [Bill Type] = {'ZLF2'} ,[KSCHL]={'Z1PR'} >} [KONV_KWERT])
 qlikviewwizard
		
			qlikviewwizard
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Attach some sample data.
 prabunakil
		
			prabunakil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
this is the database. i want to link that two field together.
 prabunakil
		
			prabunakil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		answer return error. no matching.
 prma7799
		
			prma7799
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		what error you are facing ?
 prabunakil
		
			prabunakil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		it show zero.
 prabunakil
		
			prabunakil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
i want to compare this two field and match it.
 prabunakil
		
			prabunakil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi any solution?
 prma7799
		
			prma7799
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please share QVW file
