Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ebahadur
		
			ebahadur
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Dear Qlik Fellow,
Greeting 🙂
From below sample data I want to create a graph and want to count how many "Apples" are being sold.
My dimension for graph is month and expression will be item sold, which in this case its apple.
 
					
				
		
 pedromsouza
		
			pedromsouza
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use set analysis (check Qlik help to understand syntax):
Count({$<Item={"Apple"}>} Sale)
 
					
				
		
 woshua5550
		
			woshua5550
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi
Try this
dimension : Month(Date)
expression : Count({<Item = {'Apple'}>}Item)
