Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
how to show bars in a pivot table with length corresponding to the field values group by another field?
 
					
				
		
 jafari_ervin
		
			jafari_ervin
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you can not use bar chart (mini chart) in pivot table, you can use just from gauge in pivot table.
you can implemented bar with linear gauge in pivot table.
 
					
				
		

I need to show the output in this form.
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use Linear Gauge as the 'Display Option' for your expression.

 
					
				
		
tthe example shown, though a pivot table looks like a straight table as well
bars can be used in a straight table but if it must be a pivot table, the gauge is the only option I believe to get the look you are trying toachieve
 
					
				
		
colours should be different. Using linear gauge all bars are in same colour.
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Expand the '+' sign of the expression (for the gauge), there you can set the background colors conditionally based on dimension members or such.
 
					
				
		
but i need to show different colors only on bar not on background as shown in above uploaded screen shot
 
					
				
		
Is there a way to show similar color bars in a pivot table in Qlik Sense?
 
					
				
		
 vinieme12
		
			vinieme12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Check the attached
