Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 nikhilgarg
		
			nikhilgarg
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hey,
I have a line chart. In that i want the values that goes above 102 and below 98 should be shown by red dot. How can i do that??
Please tell em the expression.
My expressionj is : Sum(Price)/Count(Price)
Thanks
 DavidFoster1
		
			DavidFoster1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use the expression formatting (the plus button on the expression in the expression list). Use simple IF logic to control the background colour of the expression
 nikhilgarg
		
			nikhilgarg
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HEy,
Thanks for hint. But actually want i want is :
I want values vhich is shown by dots to be colored only . Here whole line is colored .
How can i make the corners only colored and not whole line ??
Thanks
 
					
				
		
 senpradip007
		
			senpradip007
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you upload sample qvw?
 
					
				
		
Please upload the QVW file
 nikhilgarg
		
			nikhilgarg
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please see attached file...
I want only values to be changed in color and not whole lione.
Thanks
 nikhilgarg
		
			nikhilgarg
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please see attached file...
I want only values to be changed in color and not whole lione.
Thanks
 
					
				
		
 sivarajs
		
			sivarajs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Write a condition like below as david suggested,
Expression column is A=Sum(Price)/Count(Price)
if(A>=98 and A<=108, lightred())
 
					
				
		
 senpradip007
		
			senpradip007
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		PFA. Hope it will help.
 nikhilgarg
		
			nikhilgarg
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HEy,
I am using personal edition. So cannot open your qvw. Please tell me here what to do.
Thanks
