Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi All,
I have a bar chart in which I have plotted positive and Negative values.. Below are my requirements
1.I need to show the positive values enclosed in () i.e the display should be ($1000)
2.In the same way I need to show negative values enclosed in {} i.e {$1000)
3.By default Qlikview will show the negative values in the below axis.Is there any way that I can show the negative values above the Axis..
Awaiting for the reply..
Thanks in advance...
 
					
				
		
 vijay_iitkgp
		
			vijay_iitkgp
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please do not check money format in number tab.Go for only expression default in number tab. I am using Personal edition of QV so I cant send you apps.
 
					
				
		
Hi Vijay,
Really Thanks alot.. I dnt observe that.. BTW nice talking to you..
 
					
				
		
Hi Vijay,
Really Thanks alot.. I dnt observe that.. BTW nice talking to you..
 
					
				
		
 vijay_iitkgp
		
			vijay_iitkgp
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 Same here   
  
 
					
				
		
 stephencredmond
		
			stephencredmond
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
You might consider using a different colour for the negative bars also.
Click the "+" beside the expression in the properties and you will see a number of options. Click on "Background" and you can now define an expression to calculate the background colour - which will be the colour of the bar.
Regards,
Stephen
 
					
				
		
 vijay_iitkgp
		
			vijay_iitkgp
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 Good one Stephen. It will really help to distinguish +ve and -ve numbers 
 
					
				
		
Hi,
That is a good way of differentiating the +ve and -Ve values ..
Thanks for reply..
