Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Is possible to rename in a pie chart a field from a column?
ex:
table:
id,
customer,
status
from txt.qvd
I have the column 'customer' which contain 5 customers like :aaa, bbb, ccc, ddd, eee, fff
I would like if is possible in my pie chart to rename the customer fff to be xxx.
Is this possible in qlikview?
Kind regards
Script Solution
table:
id,
If(Match(customer,'aaa'),'fff', customer) as customer,
status
from txt.qvd
Script / Front End ???
 Frank_Hartmann
		
			Frank_Hartmann
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		try like this:
If(match(customer,'fff'),'xxx',customer)
Script Solution
table:
id,
If(Match(customer,'aaa'),'fff', customer) as customer,
status
from txt.qvd
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I would like front end
 prma7799
		
			prma7799
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Write it is in your expression
If(Match(customer,'aaa'),'fff', customer)
Or 
If(WildMatch(customer,'aaa'),'fff', customer)
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you for your answer I used to the end the script.
