setting background color on a subtotal for individual cell
Have a column using condition to set background column works fine except for the subtotal.
Solved! Go to Solution.
Hey guys - I don't think this is supported in Qlik Sense - I will open a feature in our ideation system. However, there isn't any promise this makes it into the next release / future release - we have a voting system etc and we act as your liaison for things like this. -
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Not sure how I would share app with you…..
Just trying to change background color on column using a condition. Works fine for everything other than the subtotal line.
Add this in the background colour area of the expressin, it will only format the total row
=if(rowno()=0 or isNull(rowno())
you change the colours using different RGB numbers
Sorry that doesn’t work either still no background color on the column in the subtotal line
//=IF ( COLUMN(4) > 0 AND COLUMN(5) > 0, GREEN(),
//IF ( COLUMN(4) >= 0 OR COLUMN(5) >= 0, YELLOW(),
//IF ( COLUMN(4) < 0 AND COLUMN(5) < 0, RED() )))
=if(rowno()=0 or isNull(rowno()), RGB(255,128,255), RGB(255,255,128))
michael would be of great help here. i remember he solved this 'coloring the TOTAL cell' in the past but i dont see that thread anymore in the community.