Solved: Re: background color - Qlik Community

donschmitz · ‎2018-03-01

setting background color on a subtotal for individual cell

Have a column using condition to set background column works fine except for the subtotal.

Michael_Tarallo · ‎2018-03-02

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.

Regards,

Michael Tarallo

Qlik

Regards,
Mike Tarallo
Qlik

View solution in original post

isingh30 · ‎2018-03-01

Please share your data or app.

Thank you!

donschmitz · ‎2018-03-01

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.

isingh30 · ‎2018-03-01

Add this in the background colour area of the expressin, it will only format the total row

=if(rowno()=0 or isNull(rowno())

,rgb(255,255,0)

,rgb(255,255,255)

)

you change the colours using different RGB numbers

donschmitz · ‎2018-03-01

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))

donschmitz · ‎2018-03-01

Just found the snapshot deal so here is a snapshot

YoussefBelloum · ‎2018-03-01

I suppose that you're using a pivot table..

maybe you should expand at least the first dimension to see to subtotal line and it's color ?

donschmitz · ‎2018-03-01

No Pivot table

YoussefBelloum · ‎2018-03-01

if you're looking to color the TOTAL row in a straight table, unfortunately nothing seems to work on the community...

Maybe it is not supported yet.

Qrishna · ‎2018-03-01

mto

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.

Thanks