Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Glynn1969
Contributor II
Contributor II

Colour the output of a master item expression

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

Labels (1)
3 Replies
MatheusC
Specialist
Specialist

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.

MatheusC_0-1693487308775.png

 

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Glynn1969
Contributor II
Contributor II
Author

Really sorry - not sure what you mean by call the master item and place in the condition

MatheusC
Specialist
Specialist

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

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!