Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I want to see individual rows in graph. I want to see orders against clients but if a customer has two orders, show both in the graph. For example, If customer A has 25 orders on one date and 45 orders on another date, then I want to see a bar graph which shows orders against clients. However, I would want to see both orders (stacked/grouped) seperately in the graph rather than both aggregated against customer A
How can i do this
Arif
 
					
				
		
Use the most detailed dimension(s) in the graph
Fabrice
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Add as dimension order number
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Dimensions
Customer
Date or Month
Expression = SUM(OrderValue) or COUNT(Distinct OrderNumbers)
 
					
				
		
.png) hic
		
			hic
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		All calculations in QlikView are aggregations. (Except calculated dimensions.)
So if you want one row per OrderID, you should have OrderID as dimension. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations
HIC
