Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
donschmitz
Contributor III
Contributor III

background color

setting background color on a subtotal for individual cell

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

1 Solution

Accepted Solutions
Michael_Tarallo
Employee
Employee

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

19 Replies
isingh30
Specialist
Specialist

Please share your data or app.

Thank you!

donschmitz
Contributor III
Contributor III
Author

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

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Just found the snapshot deal so here is a snapshot

YoussefBelloum
Champion
Champion

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
Contributor III
Contributor III
Author

No Pivot table

YoussefBelloum
Champion
Champion

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.

krishna_2644
Specialist III
Specialist III

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