Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 nareshthavidish
		
			nareshthavidishHi ,
How to include the text beside the total.
Below is the image for reference.

Thanks..
 Vegar
		
			Vegar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You could laborate with the dimensionality() function. See picture below where I am using " if(Dimensionality()=0,'Total sales ') & sum (Sales)" as an expression.
Cheers
Vegar
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
 
					
				
		
 annafuksa1
		
			annafuksa1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you can change it at presentation tab in chart properties

 
					
				
		
vegar.lie.arntsen Is on the right track with dimensionality...
This worked on my side:
 if(Dimensionality()<>0,
 Sum(Sales)
 ,Sum(Sales) & ' Sales') 
