Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

donschmitz
New Contributor II

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.

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: background color

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

18 Replies
isingh30
Contributor III

Re: background color

Please share your data or app.

Thank you!

donschmitz
New Contributor II

Re: background color

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

Re: background color

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
New Contributor II

Re: background color

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
New Contributor II

Re: background color

Just found the snapshot deal so here is a snapshot

YoussefBelloum
Esteemed Contributor

Re: background color

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
New Contributor II

Re: background color

No Pivot table

YoussefBelloum
Esteemed Contributor

Re: background color

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

Re: background color

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