Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Really sorry - not sure what you mean by call the master item and place in the condition
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