topic Re: background color in App Development

background color

donschmitz — Thu, 01 Mar 2018 19:44:28 GMT

setting background color on a subtotal for individual cell

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

Re: background color

isingh30 — Thu, 01 Mar 2018 20:40:14 GMT

Please share your data or app.

Thank you!

Re: background color

donschmitz — Thu, 01 Mar 2018 21:27:37 GMT

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.

Re: background color

isingh30 — Thu, 01 Mar 2018 21:33:58 GMT

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

Re: background color

donschmitz — Thu, 01 Mar 2018 21:56:25 GMT

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

Re: background color

donschmitz — Thu, 01 Mar 2018 22:01:14 GMT

Just found the snapshot deal so here is a snapshot

Re: background color

YoussefBelloum — Thu, 01 Mar 2018 22:31:39 GMT

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 ?

Re: background color

donschmitz — Thu, 01 Mar 2018 22:38:34 GMT

No Pivot table

Re: background color

YoussefBelloum — Thu, 01 Mar 2018 22:43:05 GMT

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.

Re: background color

Qrishna — Fri, 02 Mar 2018 04:49:18 GMT

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

Re: background color

isingh30 — Fri, 02 Mar 2018 14:21:41 GMT

What table is it? Straight table?

Re: background color

Michael_Tarallo — Fri, 02 Mar 2018 15:27:19 GMT

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

Re: background color

donschmitz — Fri, 02 Mar 2018 15:45:16 GMT

Thanks Michael,

An alternative would be to include extensions that would allow an image in the cell (Green.jpg, Yellow.jpg, Red.jpg)

I've look at this very little but seems rather complicated to do.

Re: background color

Michael_Tarallo — Fri, 02 Mar 2018 22:33:53 GMT

Hi Don - agreed - if you can use extensions this one is fantastic: Vizlib | Qlik Sense Extension Library

Re: background color

Qrishna — Sat, 03 Mar 2018 07:44:03 GMT

mto‌ still wondering how were you able to achieve this?

Qlik sense straight table measure color expression

Re: background color

Michael_Tarallo — Mon, 05 Mar 2018 14:24:04 GMT

Hi Krishna - that example is showing the background color expression for the selected data column in the table chart - it is not coloring the total column - it looks like that in the screen shot - but it is just the regular column:

Just an example

Background color:

if ( (Sum({<Condition={Loose},LoadDate={'$(=date(today(),'M/D/YYYY'))'}>}[Loose Price]) - Sum({<Condition={Loose},LoadDate={'$(=date(today()-1,'M/D/YYYY'))'}>}[Loose Price])) <=0,'red','green')

Text color:

if ( (Sum({<Condition={Loose},LoadDate={'$(=date(today(),'M/D/YYYY'))'}>}[Loose Price]) - Sum({<Condition={Loose},LoadDate={'$(=date(today()-1,'M/D/YYYY'))'}>}[Loose Price])) <=0,'red','white')

Re: background color

donschmitz — Wed, 02 May 2018 20:49:12 GMT

Michael,

A couple of months ago I posted this question about setting the foreground/background color on a subtotal line, and thought you said you would check with development. Any News?

Re: background color

rsing122 — Sun, 21 Oct 2018 21:19:58 GMT

Upvoting Don's question. I'm looking to et answer to this as well.

Thanks

Re: background color

donschmitz — Mon, 22 Oct 2018 14:08:17 GMT

Michael,

Any Status update on being able to change background color in Subtotal line on Straight table?

Re: background color

donschmitz — Thu, 27 Dec 2018 21:41:27 GMT

Update on this?