Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
How to provide rank to duplicate values in qlikview
 
					
				
		
 sundarakumar
		
			sundarakumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Do u want to know all the duplicates that exist and the number of times it is existing?
 
					
				
		
Untill can pls post the answer for this
 
					
				
		
yes.....i want
 
					
				
		
 sundarakumar
		
			sundarakumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please find the attached app.Get the data into a straight table, add an expression count(idfield), where idfield-> the field for which you want to find duplicates, this will show the the duplicates as count 2 and so on. Please make your requirement more clear for better understanding.
-Sundar
 
					
				
		
 sundarakumar
		
			sundarakumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please find the attached app, This is another way of doing it.
Hope this helps.
-Sundar
 
					
				
		
the document is not open in my pc..........please to give u another way
