Discussion Board for collaboration related to Qlik Education.
I have created stright table and provided condition to fact field like
Unitcost > 20 (Show in green color)
Unitcost<20 (Show in red)
if you look at the sum(Total) it also showing in Green color (as like > 20)
How can we limit the color to sum.
Go to Solution.
IF(Dimensionality() = 0, Black(),
go to Expression tab
Click on + sign of expression
Write below expression in text color
IF(SUM(Total) > 20, green(), red())
Thank you very much for the response.
Expression is not getting validated at Total with IF condition.
Provide your sample apps...
Thank you, Its working now.
Better to use in Expression tab,
Click on taggole button,
Write this expression in "Text Color"
IF(SUM(Cost) > 20, green(), red())