topic Re: Qlik Sense change background color on expression using a static row in App Development

Qlik Sense change background color on expression using a static row

MikeC-12 — Fri, 12 Nov 2021 13:30:24 GMT

I have a Qlik Sense dashboard (version Feb 2020) that I am building. One of the requirements is to have values less then 0 have a red background. The issues with this is I am using a static inline column to put the values in. The calculations I am using are very long and complicated and would prefer not to have to copy them into the background expression to make the color change. Here is a simplified version of what I am trying to accomplish.
The Data expression is like this:

if (MyRow='Row cars sold', Some calculation 1,

if (MyRow='Row Cars Traded In', Some calculation 2,

if (MyRow='Row Cars Salvaged', Some calculation 3,

If (MyRow='Row Cars Kept', Some calculation 4,

))))

I have tried the following to change the background color but none of them work. Is there something else I could try?

if ('MyRow' < 0 , Red(), Green())

if (Column(2) < 0, Red(), Green())

if ('[Cars Sold]' < 0 , Red(), Green())

Re: Qlik Sense change background color on expression using a static row

MikeC-12 — Fri, 12 Nov 2021 13:47:24 GMT

I apologize, I forgot to mention this is in a simple table.

Re: Qlik Sense change background color on expression using a static row

stevejoyce — Fri, 12 Nov 2021 13:53:28 GMT

you can reference the expression's label.

is that what Cars Sold is? if so, it wouldn't be in single quotes

if ([Cars Sold] < 0 , Red(), Green())

Re: Qlik Sense change background color on expression using a static row

stevejoyce — Fri, 12 Nov 2021 13:55:35 GMT

Also column(<measure index>) would work also. but maybe it wasnt #2. you put in the measure number, don't count the dimensions. maybe column(1) would have worked.

Re: Qlik Sense change background color on expression using a static row

MikeC-12 — Fri, 12 Nov 2021 13:56:41 GMT

Thank you Stevejoyse this worked!!