background color

[donschmitz]

setting background color on a subtotal for individual cell

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

[isingh30]

What table is it? Straight table?

[Michael_Tarallo · Accepted 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.

Regards,

Michael Tarallo

Qlik

[donschmitz]

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.

[Michael_Tarallo]

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

[krishna_2644]

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

Qlik sense straight table measure color expression

[Michael_Tarallo]

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

[donschmitz]

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?

[rsing122]

+1

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

Thanks

R

[donschmitz]

Michael,

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

[donschmitz]

Update on this?