Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Glynn1969
		
			Glynn1969
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello - apologies for what may be a basic question but i'm relatively new to qlik sense.
I have a master item with the following expression (see below) however i want the out put to be red if the result is negative and green if the result is positive - can anyone help on this. i did try an If statement but got a bit lost.
sum({<Fiscal_FY_Flag={1},[Budget Version]={'WOR','CLO'}>}[Amount - Budget]) 
- 
Sum({<Fiscal_FY_Flag={1},[Budget Version]={'WOR','CLO'}>}[Amount - Forecast])
thank you
 MatheusC
		
			MatheusC
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, @Glynn1969 
You will call your master item and place the condition.
ex:
color measurement text
if([master item]<0,'red','blue')
hope this helps.
 Glynn1969
		
			Glynn1969
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Really sorry - not sure what you mean by call the master item and place in the condition
 MatheusC
		
			MatheusC
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you created a master item for your measurement right? 
In this case, you can inform the name of this master measure created, and put the condition of the color, according to the example above
